06-12-2009 07:03 AM - edited 03-18-2019 11:11 PM
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.
06-12-2009 10:56 AM
run sql select * from car:tbl_billing_data where originalcalledpartynumber='911'
HTH
java
if this helps, please rate
06-12-2009 11:06 AM
That will work with the linux 6.1 version?
06-12-2009 12:30 PM
Works in any CUCM version
HTH
java
if this helps, please rate
06-12-2009 12:41 PM
and i run this in the SQL enterprise query?
06-12-2009 12:56 PM
No, thru CUCM CLI.
Directly on server console or SSH into server. Considering you might want to save the output, SSH into the server.
HTH
java
if this helps, please rate
04-15-2013 09:44 AM
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!!
04-15-2013 11:42 AM
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:
http://www.ucguerrilla.com/2012/03/cucm-sql-queries-installment-5.html
Anthony Holloway
Please use the star ratings to help drive great content to the top of searches.
04-17-2013 07:30 AM
I used with CUCM version 7.1. So I'm not sur where the stop and start point is. Anyway, thanks again!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide