Solved

Cisco UCCX Call Records to SQL

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How to reset UC540 2 813
UC540 Upgrade 2 43
Configuration for 1016DT with VoiP 1 115
Cisco Call Manager/ Cisco Unity Question 7 35
Every year the snow affects people and businesses. According to the Federation of Small Businesses (FSB), in 2009, UK businesses lost an estimated £1.2bn (http://news.bbc.co.uk/1/hi/business/7864804.stm) because of bad weather. This article was c…
As companies replace their old PBX phone systems with Unified IP Communications, many are finding out that legacy applications such as fax do not work well with VoIP. Fortunately, Cloud Faxing provides a cost-effective alternative that works over an…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

12 Experts available now in Live!

Get 1:1 Help Now