07-17-2024
05:27 AM
- last edited on
07-17-2024
01:33 PM
by
shule
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,
07-17-2024 11:55 PM
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.
07-18-2024 04:47 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide