cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
660
Views
5
Helpful
4
Replies

CUCM 7 CDR question

david-lima
Level 4
Level 4

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

4 Replies 4

Jaime Valencia
Cisco Employee
Cisco Employee

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

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

Thanks again

David

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

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

Getting Started

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: