09-28-2016 07:12 AM - edited 03-17-2019 08:13 AM
Hi There,
Could anyone help me get the right command to run an Sql command that will show me all the calls made to 9911 and 911 since march 24 2016?
I am not able to find anything in the CDR on cucm with !911.
run sql show all calls where callednumber is 9911 or 911 since march 24 2016
Let me know asap,
Thanks A LOT !!!!
09-28-2016 07:25 AM
Below should help
http://www.gossamer-threads.com/lists/cisco/voip/146909
Just look for the query format is you would not be using windows Call Manager.
http://www.cisco.com/c/en/us/support/docs/voice-unified-communications/unified-communications-manager-callmanager/45542-sql-queries-cdr.html
JB
09-28-2016 11:20 AM
Awesome!!
I see the results. but it doesn't include the dates.
What parameter should I include ?
09-28-2016 11:58 AM
I think it would not be able to show the date.
JB
10-14-2016 02:16 PM
I don't know which method you're using to get the CDR data but if you're downloading the CDR file from CUCM serviceability (CSV format), you can use the dateTimeOrigination field. It's in UNIX epoch time format so you need to covert it to human-readable format. I like this website for the conversion: http://www.epochconverter.com/.
Depending on how busy your CUCM system is, you may only have a couple of weeks' worth of CDR data.
I open the CSV in Excel to make it easier to work with the data. I know there's a formula in Excel to do that but I can't find it right off-hand. I sometimes import the data into an Access database and run a query for the records I need.
I copy the dateTimeOrigination data from the CSV file and paste it into the website and it converts the data to the date/time.
I hope that helps.
Bill
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: