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 [2020/02/05 15:44] – [RCD Query] gerardorourkevendors:cisco:uc:icm:sql:route [2020/02/05 15:48] (current) – [RCD Query] gerardorourke
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 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Line 33: 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 39: 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 60: 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 73: 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.1580917462.txt.gz
  • Last modified: 2020/02/05 15:44
  • by gerardorourke