11-10-2009 07:09 AM - edited 03-15-2019 08:26 PM
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
11-10-2009 08:39 AM
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
11-10-2009 10:02 AM
Hi Java, thanks a lot for your answer, just one question, where I an find the data dictionary of this tables.
Thanks again
David
11-10-2009 10:30 AM
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
11-10-2009 10:49 AM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: