Cisco UCCX Call Records to SQL
Posted on 2014-02-24
I just purchased and implemented a new CUCM with UCCX. I moved away from Avaya IP Office. The Avaya system was configured to pass the SMDR (CDR) call information to my SQL server. My DBAs then used SQL Reporting to present detailed reports of in and outbound calling.
Cisco has a similar function using CDR records. The problem is when using CTI Route points the inbound calls dialing specific DIDs are being translated into CSQs and the CSQ extensions are being logged and NOT the dialed DID. This forced us to have the Gateway Router dump the call records to a file and deliver it via SFTP.
So this is kinda messy but it is working. My last piece missing is the Outbound calling. It seems that UCCX has built in reporting that has this information. How can I link or connect into the UCCX dastabase to collect this information?
I am a newbie to the world of Cisco Voice and CUCM. I purchased this system because I was told I could get the reporting I needed and so far it has been a nightmare.