SVC_QUEUE_CAPACITIES_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: SVC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
QUEUE_ID REAL_TIME_CAPACITY NON_REAL_TIME_CAPACITY |
問合せ
| SQL_Statement |
|---|
|
SELECT queueAgents.QUEUE_ID, COALESCE(SUM(freeCaps.FREE_RT_CAPACITY)/COUNT(*),0)/100 AS REAL_TIME_CAPACITY, COALESCE(SUM(freeCaps.FREE_NON_RT_CAPACITY)/COUNT(*),0)/100 AS NON_REAL_TIME_CAPACITY FROM SVC_RESOURCE_FREE_CAPS_V freeCaps, SVC_QUEUE_AGENTS_V queueAgents WHERE freeCaps.RESOURCE_PARTY_ID = queueAgents.PARTY_ID GROUP BY queueAgents.queue_id |