CUCM 7 CDR question

Unanswered Question
Nov 10th, 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


I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Jaime Valencia Tue, 11/10/2009 - 08:39

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.



if this helps, please rate

david-lima Tue, 11/10/2009 - 10:02

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

Thanks again


david-lima Tue, 11/10/2009 - 10:30

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-lima Tue, 11/10/2009 - 10:49

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



This Discussion