CUCM 7 CDR question

david-lima · ‎11-10-2009

Hi guys, I'm running CUCM 7.0, Is there a way to obtain a specific cdr report from CLI (calling and called party number, timestamp, etc). Please share the script if you have one.

Thanks a lot

David

Jaime Valencia · ‎11-10-2009

Using the run SQL command, i'll assume you already know SQL so a simple example of all 911 calls is

run sql select * from car:tbl_billing_data where originalcalledpartynumber='911'

Refer to CDR documentation for a list of all fields and what's their content.

HTH

java

if this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

david-lima · ‎11-10-2009

Hi Java, thanks a lot for your answer, just one question, where I an find the data dictionary of this tables.

Thanks again

David

david-lima · ‎11-10-2009

Hi Java, just one more question, I have a SQL query, Is there a way to export the results from CLI admin??

Thanks gain

David

david-lima · ‎11-10-2009

Hi Java, sorry fot this one, I run the sql: run sql select authorizationcodevalue from car:tbl_billing_data where originalcalledpartynumber='3225'

But the value shows me as NULL, Do I'm missing something in the query?

Thanks again

David