Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
vendors:cisco:uc:icm:sql:route [2018/07/16 13:34] – [TCD SQL Query] gerardorourkevendors:cisco:uc:icm:sql:route [2020/02/05 15:48] (current) – [RCD Query] gerardorourke
Line 1: Line 1:
-======UCCE Route SQL======+======UCCE Route & TCD SQL======
  
 Schema Reference:\\ Schema Reference:\\
Line 13: Line 13:
  
 =====RCD Query===== =====RCD Query=====
-<code>+<code sql>
 SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON  SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON 
 +SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
  
-SELECT  TOP (1000)+SELECT  TOP (8001)
  RouteDateTime = Route_Call_Detail.DateTime  RouteDateTime = Route_Call_Detail.DateTime
 ,CallStartDateTime = Route_Call_Detail.BeganRoutingDateTime ,CallStartDateTime = Route_Call_Detail.BeganRoutingDateTime
Line 32: Line 33:
 ,RCDLabel = Route_Call_Detail.Label ,RCDLabel = Route_Call_Detail.Label
 ,RouterQueueTime = Route_Call_Detail.RouterQueueTime ,RouterQueueTime = Route_Call_Detail.RouterQueueTime
-,CASE Route_Call_Detail.RouterErrorCode +,'RouterErrorCode' = CASE (Route_Call_Detail.RouterErrorCode)
 WHEN '0' THEN 'OK' WHEN '0' THEN 'OK'
 WHEN '448' THEN 'Abandoned' WHEN '448' THEN 'Abandoned'
Line 38: Line 39:
 WHEN '66' THEN 'No Default Label' WHEN '66' THEN 'No Default Label'
 ELSE CAST (Route_Call_Detail.RouterErrorCode AS VARCHAR(10)) ELSE CAST (Route_Call_Detail.RouterErrorCode AS VARCHAR(10))
-END AS 'RouterErrorCode' +END  
-,CASE Route_Call_Detail.TargetType+,TargetType = CASE (Route_Call_Detail.TargetType)
 WHEN '0' THEN 'Call routing ended badly' WHEN '0' THEN 'Call routing ended badly'
 WHEN '1' THEN 'DefaultRouteCall' WHEN '1' THEN 'DefaultRouteCall'
Line 59: Line 60:
 WHEN '22' THEN 'RouteToPrecisionQueue' WHEN '22' THEN 'RouteToPrecisionQueue'
 ELSE CAST (Route_Call_Detail.TargetType AS VARCHAR(10)) ELSE CAST (Route_Call_Detail.TargetType AS VARCHAR(10))
-END AS TargetType+END 
 ,RequeryResult = Route_Call_Detail.RequeryResult ,RequeryResult = Route_Call_Detail.RequeryResult
 ,VruProgress = Route_Call_Detail.VruProgress ,VruProgress = Route_Call_Detail.VruProgress
Line 72: Line 73:
 ,Var9 = Route_Call_Detail.Variable9 ,Var9 = Route_Call_Detail.Variable9
 ,Var10 = Route_Call_Detail.Variable10 ,Var10 = Route_Call_Detail.Variable10
 + 
 FROM  FROM 
 Route_Call_Detail(nolock) Route_Call_Detail(nolock)
  • vendors/cisco/uc/icm/sql/route.1531744457.txt.gz
  • Last modified: 2018/07/16 13:34
  • by gerardorourke