CDR Reporting? What is a CDR Report?
CDR (Call Detail Record) – According to the definition given webopedia, in IP Telephony, a call detail record is a data record that contains information related to a telephone call, such as the origination and destination addresses of the call, the time the call started and ended, the duration of the call, the time of day the call was made and any toll charges that were added through the network or charges for operator services, among other details of the call.
Source : – http://www.webopedia.com/TERM/C/call_detail_record.html
How to configure CDR Report?
- Login to Cisco Unified Communication Manager
- Go to System -> Service Parameters –> Select Server as appropriate CUCM Server & Service as Cisco Call Manager (Active)
- Search the field CDR Enabled Flag Required Field and set it as True & CDR Log Calls with Zero Duration Flag as True
- Click on Save
How to access CDR Report?
- Login to CUCM CAR Reporting Tool https://x.x.x.x:8443/car/
- Go to CDR -> Export CDR/CMR records
- Select From Date (Date since when you want the CDR Report
- Select To Date (Date till when you want the CDR Report)
- Check Mark CDR Record and Unckeck CMR Record
- Export To File
- Save the file in your Desktop/Laptop to the location/drive you want to save
How to open the CDR Report?
- Ensure that Microsoft Excel is installed in your system.
- Open Excel Application -> Go to File -> Open -> Select All Files in Files of Type and Select the downloaded CDR Report and Click on Open
- Select Delimited and Click on Next
- Check Mark Tab and Comma and click on Finish and here you go. Now you can see all the fields are popped up.
There are many fields in the CDR Report and the utility of these fields are important based on your requirement.
If you want only Calling Party Number, Called Party Number, Duration and Date and Time of Call then you need to ensure that you keep the following
- Differentiate between Restricted CUCM and Unrestricted CUCM - March 12, 2018
- Re-enable debugs on router reload – EEM Script - March 12, 2018
- Configure Cisco CUBE SIP Options Ping - January 30, 2018
- Unified Messaging with Cisco Unity Connection & Office 365 - January 4, 2018
- Transfer/Hold/Conf Buttons Not Working – Cisco 78XX IP Phone - November 20, 2017
- Track Media Resource (Transcoder) Utilization via RTMT - November 15, 2017
- Installation & Configuration of Expressway C & E – MRA - September 17, 2017
- CUCM BAT Import Error 19145 An Alternate Number can only… - August 30, 2017
- Cisco Jabber Auto Discovery Service – SRV Records - July 15, 2017
- Running VMWare ESXi 60 days trial license? Reset the license - July 15, 2017