cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
408
Views
0
Helpful
2
Replies
balitewiczp
Explorer

SQL Query for transferred numbers

Does someone know what SQL table is modified when an UCCE agent transfers a call using the finesse client, as well as where the call was transferred to?  I can see the call in TCD, and I see the call disposition of "transfer" , but I do not see where it was transferred to.  I am ultimately interested in creating a cuic report showing this

 

thanks

2 REPLIES 2
Basudev_Cisco
Beginner

Hello,

 

Transferred calls can be best seen in Route_Call_Details and Termination_Call_Details table. In your ICM Script, set your destination in a Call variable (1-10) and in TCD it will show you where the calls is routed too. Also if you want to create a report to count the transferred call, you can do it with Call Disposition values where code 28 is blind transfer and 29 is consult transfer.

 

Thanks,
Basudev

piyush aghera
Enthusiast

Hi,

Have a look at DigitsDialed  field of Termination_Call_Details table, which stores the number that was dialed.

Content for Community-Ad

Spotlight Awards 2021