Differences

This shows you the differences between two versions of the page.

--- myapps:tickertape:sql [2021/01/15 16:12] – created gerardorourke
+++ myapps:tickertape:sql [2021/01/15 16:33] (current) – [TEMP EWT] gerardorourke
@@ Line 28: / Line 28: @@
 </code>
+<code sql>
+select
+ewtsg.skillgroup_id
+,eg.name
+,DefaultAvgHandledTime = SGAHT.avghandletime
+,[RouterCallsQNow]
+,[AvgHandledCallsTimeTo5]
+,[Ready]
+,[TalkingIn]
+,[TalkingOther]
+,[TalkingOut]
+,[RouterLongestCallInQ]
+,AgentsTalking = (TalkingIn+TalkingOut+TalkingOther)
+from [ewtgroup_skillgroup] ewtsg
+JOIN [ewtgroup] eg ON eg.id = ewtgroup_id
+JOIN [Skill_Group_Real_Time] SGRT ON SGRT.SkillTargetID = ewtsg.skillgroup_id
+LEFT JOIN [skillgroup_avghandletime] SGAHT ON SGAHT.id = ewtsg.skillgroup_id
+</code>