obtaining call records from CDR

Unanswered Question
Jun 12th, 2009

I am running CCM 6.1

We need to pull our call records for a certain ext. THe problem i am having is in CDR is I go to CDR/search/User extensions and search.

It will only show 100 records and trunkcate the other. Now I need to pull 3 months worth and it would be to time consuming to do each day and copy it to a report.

I also attempted to goto device reports/gateway/detail and will puill ever 3 days the entire logs. This will put it in the PDF and allow me to search for that ext but its will not copy out of the PDF properly and I need to only show the ext I want.

Does anyone know a way I can get a detailed call report for only 1 ext that will not truncate the results? or another way I can access this.

In our older version of call manager (4.1) i was able to load sql and do a search on the DB and just copy the results out.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Jaime Valencia Fri, 06/12/2009 - 10:56

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



if this helps, please rate

Jaime Valencia Fri, 06/12/2009 - 12:56

No, thru CUCM CLI.

Directly on server console or SSH into server. Considering you might want to save the output, SSH into the server.



if this helps, please rate

techie2008_2 Mon, 04/15/2013 - 09:44

The script worked like a charm in Putty!!  The out put came out garbled, but I copied it to the clipbaord and put it on Notepad and it was great!  Thanks so much!!

Anthony Holloway Mon, 04/15/2013 - 11:42

Since this old post is being revived, I should mention that in recent versions (too lazy to research exact) of CUCM, the syntax has changed slighty, and the above given command no longer works.

The new syntax is:

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

EDIT: In our very own forum member Will's blog, he states it was a change from 7x to 8x:


Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

techie2008_2 Wed, 04/17/2013 - 07:30

I used with CUCM version 7.1.  So I'm not sur where the stop and start point is.  Anyway, thanks again!


This Discussion