Solved

Cisco UCCX Call Records to SQL

Posted on 2014-02-24
2
1,281 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
QoS on 2960X 3 105
Cisco VOIP 7941 6 95
Need help understanding which home office phone will work with wireless headset 5 63
change extension to new user 5 17
I recently purchased a Bluetooth headset called the Music Jogger (model BSH10). The control buttons on it look like this: One of my goals is to use it as the microphone and speakers for Skype calls. In that respect, it works well. However, I …
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now