02-27-2018 09:03 AM - edited 03-14-2019 05:59 PM
Hi,
Does anyone know of a query that I can run that will show me what ICM script node the call was last seen at?
I find live monitor to busy to pin point where a particular call is ending up.
Thanks
02-27-2018 10:26 AM
02-27-2018 11:16 AM
02-28-2018 09:39 PM
Both responders are correct.
I often use a query like this (but I am mindful of the performance implications on a high call system)
DECLARE @start DateTime SET @start = '2018-02-28 00:00:00' DECLARE @end DateTime SET @end = DATEADD(dd, 1, @start) SELECT BeganRoutingDateTime ,rcd.RoutingClientID AS RCID ,RouterCallKey AS RCK ,CASE rcd.RequestType WHEN 1 THEN 'Pre-Route' WHEN 2 THEN 'Blind Transfer' WHEN 3 THEN 'Ann Transfer' WHEN 4 THEN 'Overflow' WHEN 5 THEN 'Reroute' WHEN 6 THEN 'Post-Route' END AS Req_Type ,DialedNumberString AS DNS ,ANI ,ms.EnterpriseName AS Script ,ct.EnterpriseName AS FinalCallType ,Label ,RouterErrorCode AS REC ,RouterQueueTime AS RQT ,Variable1 ,Variable2 ,Variable3 ,Variable4 ,Variable5 FROM Route_Call_Detail AS rcd FULL OUTER JOIN Script AS s ON (s.ScriptID=rcd.ScriptID) FULL OUTER JOIN Master_Script AS ms ON (ms.MasterScriptID=s.MasterScriptID) INNER JOIN Call_Type AS ct ON (ct.CallTypeID=rcd.CallTypeID) INNER JOIN Routing_Client AS rc ON (rcd.RoutingClientID=rc.RoutingClientID) WHERE rcd.DateTime > @start AND rcd.DateTime < @end ORDER BY BeganRoutingDateTime
Make modifications to suit.
Regards,
Geoff
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide