SVC_QUEUE_CAPACITIES_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
QUEUE_ID REAL_TIME_CAPACITY NON_REAL_TIME_CAPACITY

Query

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