<div>
<div class="content wysiwyg-content">
I just purchased and implemented a new CUCM with UCCX. &nbsp;I moved away from Avaya IP Office. &nbsp;The Avaya system was configured to pass the SMDR (CDR) call information to my SQL server. &nbsp;My DBAs then used SQL Reporting to present detailed reports of in and outbound calling.<br />
<br />
Cisco has a similar function using CDR records. &nbsp;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. &nbsp;This forced us to have the Gateway Router dump the call records to a file and deliver it via SFTP. &nbsp;<br />
<br />
So this is kinda messy but it is working. &nbsp;My last piece missing is the Outbound calling. &nbsp;It seems that UCCX has built in reporting that has this information. &nbsp;How can I link or connect into the UCCX dastabase to collect this information?<br />
<br />
I am a newbie to the world of Cisco Voice and CUCM. &nbsp;I purchased this system because I was told I could get the reporting I needed and so far it has been a nightmare.<br />
<br />
Please help!!
</div>
</div>


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.

Please help!!

Cisco UCCX Call Records to SQL

Voice over IP (VoIP) is a methodology and group of technologies for the delivery of voice communications and multimedia sessions over Internet Protocol (IP) networks, such as the Internet. Other terms commonly associated with VoIP are IP telephony, Internet telephony, broadband telephony, and broadband phone service. The term specifically refers to the provisioning of communications services (voice, fax, SMS, voice-messaging) over the public Internet, rather than via the public switched telephone network (PSTN).  Examples of the VoIP protocols are H.323, Media Gateway Control Protocol (MGCP), Session Initiation Protocol (SIP), H.248 (also known as Media Gateway Control (Megaco)), Real-time Transport Protocol (RTP), Real-time Transport Control Protocol (RTCP), Secure Real-time Transport Protocol (SRTP), Session Description Protocol (SDP), and Inter-Asterisk eXchange (IAX).