Identity unique column in Cisco TCD and CDR table OB Manual Dial

[Umair Tanveer]

Hi Everyone,

While Outbound manual dialing ,

I want to join the Cisco TCD and CDR table through the link server but couldn't find any unique column in either table. Please help me identify it so I can join both tables for that unique key value to retrieve combined data. Thanks,

[Shalid Kurunnan Chalil]

Hi there, 

Are you referring to the TCD from the UCCE/ICM DB and the CDR from the Call Manager system?

Your best bet is to use the ANI of the call, the agent extension, and the time in the both tables/DB, as there are no correlated IDs or unique attributes in any of the UCCE tables that connect both systems in this instance.

Regards

Disclaimer:

Responses are based on personal knowledge and experience. Consider them as guidance. Other members may offer different perspectives or better approaches. No responsibility is assumed for outcomes; discretion is advised.

[bill.king1]

Take a look at this post and some of the links that they have in it from Cisco Live, this may give you what you need.
https://community.cisco.com/t5/contact-center/linking-a-call-between-vg-icm-and-callmanager-ucm/td-p/2997331