Differences

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

--- vendors:cisco:uc:icm:sql:config [2018/05/17 19:56] – ↷ Page moved from code:java:vendors:cisco:uc:icm:sql:config to vendors:cisco:uc:icm:sql:config gerardorourke
+++ vendors:cisco:uc:icm:sql:config [2022/11/22 12:25] (current) – [Reason Codes] gerardorourke
@@ Line 156: / Line 156: @@
   FROM [ucce_awdb].[dbo].[Reason_Code]
  </code>
+==== Dialed Numbers, CallTypes, Skillgroups, Count ====
+<code sql>
+SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON
+SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
+SELECT TOP (8001)
+ DigitsDialed = TCD.DigitsDialed
+,CallTypeID=TCD.CallTypeID
+,CallTypeEnterpriseName=Call_Type.EnterpriseName
+,SkillGroupName = Skill_Group.EnterpriseName
+,RoutedSkillGroupSkillTargetID=TCD.RoutedSkillGroupSkillTargetID
+,Total = Count(*)
+  FROM
+  Termination_Call_Detail (nolock) TCD
+  LEFT JOIN Peripheral (nolock) ON (TCD.PeripheralID = Peripheral.PeripheralID)
+  LEFT JOIN Media_Routing_Domain (nolock) ON (TCD.MRDomainID = Media_Routing_Domain.MRDomainID)
+  LEFT JOIN Skill_Group (nolock) ON (TCD.RoutedSkillGroupSkillTargetID = Skill_Group.SkillTargetID)
+  LEFT JOIN Precision_Queue (nolock) ON (TCD.PrecisionQueueID = Precision_Queue.PrecisionQueueID)
+  LEFT JOIN Call_Type (nolock) ON (TCD.CallTypeID = Call_Type.CallTypeID)
+ WHERE
+  TCD.DateTime > GetDate()-10
+  AND TCD.PeripheralID IN (5002)
+  AND TCD.CallTypeID <> -1 -- Removes Outbound Calls
+  AND TCD.DigitsDialed is NOT NULL
+GROUP BY
+TCD.DigitsDialed,
+TCD.CallTypeID,
+Call_Type.EnterpriseName,
+Skill_Group.EnterpriseName,
+TCD.RoutedSkillGroupSkillTargetID
+ORDER BY
+COUNT(*) DESC, TCD.DigitsDialed, Call_Type.EnterpriseName, Skill_Group.EnterpriseName
+</code>