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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Querying CDR Database

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!

2 ACCEPTED SOLUTIONS

Accepted Solutions
VIP Super Bronze

Re: Querying CDR Database

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)

Please remember to rate helpful responses and identify helpful or
Cisco Employee

Re: Querying CDR Database

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
3 REPLIES
VIP Super Bronze

Re: Querying CDR Database

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)

Please remember to rate helpful responses and identify helpful or
Cisco Employee

Re: Querying CDR Database

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

HTH

java

if this helps, please rate

www.cisco.com/go/pdi

Re: Querying CDR Database

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.

609
Views
0
Helpful
3
Replies