Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Query for CDR

Hi,

I have recently preformed a CCM upgrade (4.1->6.1) at one of my customer's. The customer (his admin to be correct) is used to collecting CDRs with SQL queries and making his own reports out of them. Now as we upgraded CCM he wants the same. I showed him how he can now get csv files, export them to Excel an perform whatever he needs. However he still wants to be able to preform queries on DB itself. Is this possible? How? If it's not done like this anymore, I want to prove it to him so he can get used to excel...

Any help is appreciated,

Goran Pilat

3 REPLIES
Cisco Employee

Re: Query for CDR

he still can do that:

run sql

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/cucos/6_1_1/cucos/iptpappa.html#wp1052698

you can look at the data dictionary for the DB schema to create the qrys

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: Query for CDR

Hi,

Since CCM release 5.x direct access to the database is not allowed anymore so the recommendation for processing CDRs is to move the CDR text based records off the CCM to an external application and process the CDRs there. CCM periodically uploads the CDRs to an external server using FTP.

If database style processing of records (SQL queries) is a must, any medium level programmer can develop an small script so you can insert each CDR record into a true SQL database (MS SQL Server, MySQL, Postgres, whatever suits your mood), then you can have all the tools, statements, etc. provided by the chosen database at your dipsosal.

I myself made such an script some months ago in order to transfer all the TXT records from CCM 5.x / 6.x to a MySQL database), I may post it here if you're interested.

Regards.

New Member

Re: Query for CDR

Hi Jaime,

If it is not a problem to you, please post the script. Thanks for your great explanation,

All the best in New Year

Pilat Goran

183
Views
5
Helpful
3
Replies
CreatePlease to create content