Solved

Cisco UCCX Call Records to SQL

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Wireless Voice Quality 2 61
Active Directory DirSync to Office 365 4 49
Auto-Dialers 3 67
VoIP and Data on single switch, with SonicWall 6 72
In my office we had 10 Cisco 7940G IP phones that were useless as they were showing PROTOCOL APPLICATION INVALID when started. I searched through Google and worked for a week continuously on those phones, and finally got them working. This is a di…
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 …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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