cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
578
Views
0
Helpful
4
Replies

CUCM report

ali ezzat
Level 1
Level 1

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

4 Replies 4

jeremy.worden
Level 1
Level 1

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

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 ? 

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.



Response Signature


RezaNazari3290
Level 1
Level 1

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/