Configuring Cisco Call Detail Record (CDR)

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.

CDR Report Full
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

callingPartyNumber finalCalledPartyNumber duration dateTimeOrigination

CallingPartyCalledPartyDurationDateandTime

You may also like...

21 Responses

  1. Will says:

    Wanted to say thanks a ton for this information. I know literally nothing about CUCM (systems engineer not voice) and we had a customer desperate for this information today. I was able to save their day by using your instructions.

  2. I wrote a Python script that searches a CSV file with CDR data from CUCM for a given extension, and outputs the data/time, duration, calling and called numbers to a new CSV file to import into Excel. It also converts the epoch date/time to a human readable format.

  3. Claudio says:

    I red your post about CDR UCM and I downloaded the TXT file from CDR UCM according your guidelines, but the file was in blank. It was empty. I tried with differents dates with the same result. The files was completely in blank. Could you help me in order to get the right CDR file from UCM?

    • Hello Claudio,
      As we had a session and i was able to see that you did not complete all the steps. The steps you missed in Service Parameter to enable the Flag as True. In the session with you, i enabled the Flag as True and you were able to see the CDR Record.
      Thanks!!

  4. Claudio says:

    Your post is really good and your support is better.
    Thank you for your time once again!

  5. Long Nguyen says:

    your guide: “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
    callingPartyNumber finalCalledPartyNumber duration dateTimeOrigination”
    I don’t know: how to filter CDR Report some fields what I need?
    please help me!

    • Hello Long Nguyen,
      Thank You for following my blog.
      If i have understood your requirement clearly, you are trying to filter few columns only like “Calling Party”, “Called Party”, “Duration”, “Date and Time”. If this is the case, either you have to import the file into excel sheet and delete unwanted columns which you don’t need. Alternative the other way to sort the columns in a very easy manner is to open the in Microsoft Access and then sort it out. I had used Microsoft Access almost 5 years ago and i remember that it does the job.
      I have customized a report for you which will help you a lot to Filter the above columns only.
      https://drive.google.com/file/d/0By_XXeeS_QmeNGVIU2ZYRnIzZ28/view?usp=sharing
      Download the excel sheet from above link and ensure that Macros is enabled. Go to CDR Dump Page and Paste all the CDR Dump into the sheet starting from Column A1. Then Go to Filter Tab and Click on Extract and it will extract only “Calling Party”, “Called Party”, “Duration”, “Date and Time”. If you are not seeing the correct headers, please send me your CDR DUMP and let me know what columns you would like to see in the Filtered Sheet. I will create an automation for your which will show you the columns which you want.
      For more usage – You may follow this link that i have created – https://uccisco.wordpress.com/2015/07/19/cisco-cdr-reporting-a-handy-book/
      Let me know if you have any concerns
      Thanks!!

  6. Long Nguyen says:

    Dear avinashkarnani11,
    Thank You so much for help me solve this issue.
    if I have any questions I will ask you later.
    one again thank you very much!

  7. Arpi says:

    Do you know of anyway to automate the extract of the CDR record. We extract Sunday to Saturday data and would like to automate it.

  8. abbas amiri says:

    Hi, I have a problem with exported report to Excel. The Phone Number field format in excel is very strange although and I can not match it ti any other Phone Number from Oracle report. I have tried different type of format but it did not work. can you pls help me to understand the format of that field pls. Thanks a million.

    • Administrator says:

      Hi Abbas,
      When you say Oracle Report, what do you mean? Have you downloaded the CDR from CUCM and then opened with Excel as directed? Please provide more information so that we can help you.

  9. Gustavo says:

    Buen post,
    ¿El campo “duration”, esta en segundos o minutos?
    ¿Sabes como cambiar el formato del campo “dateTimeOrigination”?
    Gracias.
    Google translate:
    Good post,
    Is the “duration” field in seconds or minutes?
    Do you know how to change the format of the field “dateTimeOrigination”?
    Thank you.

  10. nathan lickey says:

    I would love help troubleshooting CDR records. I enabled CDR and have been pulling records from it for quite awhile and all of a sudden our records are blank, only the headers are available. I have restarted the service by falsing the flag and true it again. I have stopped the load and re-enabled it for 24/7 loading. All to no avail. Anyone have this issue??? Is there a buffer that has filled up and records need to be deleted?

  11. xmariboo@gmail.com says:

    Hi
    hope u are doing well
    these unlimited licenses are available
    if u need u can remotely check my server and do whatever u want
    email: xmariboo@gmail.com
    skype: xmariboo@gmail.com

    1-Cisco CUCM 9.X 10.X 11.X 12.X 14.X crack
    2-Cisco unity 11,12 crack
    3-Cisco expressway 12.5
    4-Cisco webex3.x / 4.x
    5-Cisco ASAv Crack
    6-Fortigate Crack license
    7-Imagicle call recording and billing crack
    8-Cisco ISE 2.7 (10000 Node)
    9-Cisco Prime
    10- PRTG NCM / NPM
    11- Vmware / ESXi all versions license
    12- ….

  1. April 19, 2020

    […] but also helps in troubleshooting purposes. In case you missed to read the article published by us, you can follow this link. The raw CDR processed via Call Manager contains 120+ columns and huge number of raws (depending on […]

Leave a Reply

Your email address will not be published. Required fields are marked *