CUCM report

[ali ezzat]

Dears,

Hope all is good, I need to export simple report from CUCM that including ( src + destination + duration +date and time)

i know that i can use CDR but too much info i only need the simple one.

is it can done by CUCM reports or only can do it via another program like VOIP detective ?

thanks

[jeremy.worden]

A quick and dirty way to get this would be via an SQL query:

run sql car select datetimeOrigination,callingPartyNumber,finalCalledPartyNumber,originalcalledpartynumber,duration,datetimeorigination from tbl_billing_data

You could also connect CUCM to Webex Control Hub and use Connected UC to view call logs.

Otherwise you can just export the records via the GUI and view in Excel.

https://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/4_0_1/ccmsrva/sacar7.html

[ali ezzat]

Thanks for your reply 

But i am not a familiar with CUCM as i am a network SDA engineer , if you give me more details about how to di this SQL run ? 

[Roger Kallberg]

If your not familiar with CM it is recommended that you hand this over to someone who is. Running SQL queries is not something that you should do if you don’t know what your doing.

[RezaNazari3290]

Ali,
There is an easier method using Python to achieve exactly what you’re looking for.

Please see the link below for the Python script and further instructions. It’s pretty easy to set up. This is what I always use and it works like a champ. 

https://www.uccollabing.com/python-script-to-extract-call-record-from-cisco-cdr/