Configuring Cisco Call Detail Record (CDR)

Hello Everyone,

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

Configuring Cisco Call Detail Record (CDR) was last modified: January 29th, 2016 by Administrator

18 thoughts on “Configuring Cisco Call Detail Record (CDR)”

  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.

    1. avinashkarnani11 says:

      Thank You Will !! Appreciate that my blog helped you..

  2. Steve Campbell says:

    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.

    1. avinashkarnani11 says:

      Hello Steve,

      Appreciate you taking time to read my post. It would be really great if we can learn your python script and it’s uses to fetch the info as you mentioned.

  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?

    1. avinashkarnani11 says:

      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!

    1. avinashkarnani11 says:

      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.

    1. avinashkarnani11 says:

      Hi Arpi,

      What fields you would like to automate? If you would like to automate only Calling Party”, “Called Party”, “Duration”, “Date and Time”, please follow and download the sheet from https://drive.google.com/file/d/0By_XXeeS_QmeNGVIU2ZYRnIzZ28/view?usp=sharing

      You may also refer to – https://uccisco.wordpress.com/2015/07/19/cisco-cdr-reporting-a-handy-book/

      Let me know if you have any questions.

      1. Arpi says:

        HI, Thank you for that. I would like to setup the CDR dump to occur on a Monday morning for the previous week. Is that possible at all. We then bring in the data to SQL reporting services. Currently we have to go to the reporting tool enter the parameters and manually save the file. I want to be able to automate the process.

        Cheers
        Arpi

  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.

    1. 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.

Leave a Reply

Show Buttons
Hide Buttons