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

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/devguide/8_0_1/serviceability.html#wp1058811

Programming Guides

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

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.

Actions

Login or Register to take actions

This Discussion

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

Discussions Leaderboard

Rank Username Points
1 21,026
2 15,047
3 10,314
4 7,999
5 4,856
Rank Username Points
154
95
75
66
55