SQL Query for transferred numbers

[balitewiczp]

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

[Basudev_Cisco]

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]

Hi,

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