Cisco CDR (Call Detail Records) has all the details of all the calls made in a text format. In this post let's see how we can get more information like time and duration of a call made .
Go to Unified Serviceability page from Navigation and log into the Call Manager.
(click on images to view in full size)
Select CDR Analysis & Reporting from Tools tab
Then select Export CDR/CMR from CDR tab
Then select the date range you want and untick CMR records and click Export to File
Then the result will be a link to CDR Dump. Right click on it and Save link as a text file
Then don't open it directly from the file as it is in raw data mode. Go to Microsoft Excel and open the saved CDR text file. This Text Import Wizard will popup. Click Next
Tick Comma and click Next
Click Finish
You will see data in following format.
Most important columns are
dateTimeOrigination (Time of the call initiated) - column E
callingPartyNumber (Originator/Source of the call) - column I
originalCalledPartyNumber (Destination) - column AD
duration (Duration) - column BD
=(E2+19800)/86400+DATE(1970,1,1)
E2 is the 1st cell with a value of dateTimeOrigination column
Go to Unified Serviceability page from Navigation and log into the Call Manager.
(click on images to view in full size)
Select CDR Analysis & Reporting from Tools tab
Then select Export CDR/CMR from CDR tab
Then select the date range you want and untick CMR records and click Export to File
Then the result will be a link to CDR Dump. Right click on it and Save link as a text file
Then don't open it directly from the file as it is in raw data mode. Go to Microsoft Excel and open the saved CDR text file. This Text Import Wizard will popup. Click Next
Tick Comma and click Next
Click Finish
You will see data in following format.
Most important columns are
dateTimeOrigination (Time of the call initiated) - column E
callingPartyNumber (Originator/Source of the call) - column I
originalCalledPartyNumber (Destination) - column AD
duration (Duration) - column BD
Note:-
To find the local date & time you have to use following formula in Excel in a separate column.
=(E2+19800)/86400+DATE(1970,1,1)
Then correct the format of the cell
E2 is the 1st cell with a value of dateTimeOrigination column
+19800 is the value which should be added for my local time (number of seconds for +5.5 hours from Greenwich meantime)
Or you can use this simple tool to get the time. But you will have to use it for one after one. At least it will be helpful to get the formula verified.
