Solved: Querying CDR Database

robert-rittenhouse · ‎09-07-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!

Jonathan Schulenberg · ‎09-08-2010

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)

View solution in original post

Jaime Valencia · ‎09-08-2010

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

View solution in original post

Jonathan Schulenberg · ‎09-08-2010

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)

Jaime Valencia · ‎09-08-2010

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

robert-rittenhouse · ‎09-08-2010

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.