Querying CDR Database

Answered Question
Sep 7th, 2010

I am running CUCM 7.1.3 and I am wanting to write my own web application that will let me query data from the CDR database. I keep finding resources that show on the older systems (when they ran Windows) you would just connect to the sql server and query. I fear that it's not so simple these days and there is a different method of doing so. My guess is some kind of SOAP or XML call ?

Thank you!

I have this problem too.
0 votes
Correct Answer by Jaime Valencia about 3 years 7 months ago

You can also qry directly the DB

CDRonDemand SOAP Service


Programming Guides




If this helps, please rate


Correct Answer by Jonathan Schulenberg about 3 years 7 months ago

UCM will FTP flat files of the CDR records to a server of your choosing. It's up to your application to parse them and load the records into SQL.

Cisco Unified Serviceability Administration Guide, Release 8.0(2) - CDR Repository Manager

Cisco Unified Communications Manager Call Detail Records Administration Guide, Release 8.0(2)

  • 1
  • 2
  • 3
  • 4
  • 5
Average Rating: 5 (2 ratings)
robert-rittenhouse Wed, 09/08/2010 - 09:54

Thank you for the excellent replies as usual. I stumbled upon the cisco developer portion of the website yesterday after I asked but I figured a push in the right direction couldn't hurt.

Do you know if there are any open source products that connect and do (even basic) CDR querying?

Also, if I am reading right, you make a SOAP request and you end up downloading a file from it with the results? Logic (i think?) would tell me that it would be returned in the SOAP reply, right? I haven't used it as much as I should.

Again, thank you both.


Login or Register to take actions

This Discussion

Posted September 7, 2010 at 11:53 AM
Replies:3 Avg. Rating:5
Views:573 Votes:0
Tags: No tags.

Discussions Leaderboard

Rank Username Points
1 21,036
2 15,047
3 10,325
4 8,014
5 4,856
Rank Username Points