Solved

Cisco UCCX Call Records to SQL

Posted on 2014-02-24
2
1,295 Views
Last Modified: 2014-03-01
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!!
0
Comment
Question by:BSModlin
2 Comments
 
LVL 20

Accepted Solution

by:
agonza07 earned 250 total points
ID: 39887019
0
 
LVL 20

Assisted Solution

by:José Méndez
José Méndez earned 250 total points
ID: 39893179
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
HP ProCurve and tagging 5 114
Need recommendation for complete telephone system 5 61
Lync - CUCM Integration Question 2 29
Need help with VLAN issue 6 59
Article by: user_n
How Sip Phone (User Agent) works and communicates with sip servers 1.  There is a sip server and a sip registrar.  The sip server and sip registrar can be one server or two different servers. The sip registrar is the server on which it is record…
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question