Track the Incoming call to the ICM system
- Following query can be utilized to track the Incoming call to the ICM system
- Determine the respective Script and the LAST successful or point of failure node involved in routing the given call
- Helps to track down the call details and attributes for further debugging
t_Route_Call_Detail
Query can be utilized with any of the following combinations
- Date and Time range + *ANI (Most accurate)
- ANI
- DialedNumber String
By dateTime
![](https://ucce.ciscoar.com/wp-content/uploads/2024/07/image-345-1024x65.png)
Select * from t_Route_Call_Detail where DateTime between '2020-04-29 13:00' and '2020-04-29 13:30’
![](https://ucce.ciscoar.com/wp-content/uploads/2024/07/image-348-1024x214.png)
by Given DateTime with ANI
![](https://ucce.ciscoar.com/wp-content/uploads/2024/07/image-346.png)
Select * from t_Route_Call_Detail where DateTime >'2020-04-29 12:00* and ANI like '*10008%'
by Given DialedNumber String
![](https://ucce.ciscoar.com/wp-content/uploads/2024/07/image-347-1024x75.png)
Select * from t_Route_Call_Detail where DateTime >'2020-04-29 13:00' and DialedNumberString like ’*9941970776%'