UCCE query for final script node

[Stuart C]

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

[david.macias]

In the DB look at the Route_Call_Detail table specifically FinalObjectID.

david

[Shalid Kurunnan Chalil]

This can obtain from route call detail table where you can find the script
and finalobjectid.

Final object is the last node where call terminated in ICM script.

If you want to re assure the final script then
Note down the script id from RCD table and find out the masterscriptid
from table Script


Run the query using this masterscriptid agianst Master_Script. You will get
the script name.

[geoff]

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