Python Script to Extract Call Record from Cisco CDR
Python Script to Extract Call Record from Cisco CDR
There is a python script written by Steve Campbell which extracts Call Detailed Record (CDR) for an extension using Python Script. Extraction of the record is quite simple and faster. The only drawback i see at this time is it can run the script against one extension only at a time which means you can search only one extension number in the whole CDR Report.
The script will pull out Data/Time, Duration, Calling Number and Called Number from raw CDR Report.
Procedure:
- To start using the Python Script, you need to have Python installed in your PC. You can download python from official website (“https://www.python.org/downloads/“).
- Once the software is downloaded, you need to install the application in your PC.
- Download Python Script from https://github.com/sdcampbell/PyCDR site and copy the files from the folder PyCDR-master to Python Directory.
To Find Python Directory, follow either of the below steps:
OPTION 1
“C:\Users\USERNAME\AppData\Local\Programs\Python\Python36-32\”(Replace USERNAME with your actual Username of Windows Machine)
OPTION 2
Click on Start Menu
Type Python in the Search Program and File box
Right Click on Python 3.6 (32 bit) or (64 bit) and click on Open file location
A window will open; click on the address bar and copy the location from the address bar - Also download CDR Raw Data from Cisco Unified Communications Manager and copy it in the python directory as shown in the above step
- Now open Command Prompt and execute the command
C:\> CD C:\Users\USERNAME\AppData\Local\Programs\Python\Python36-32\
OR
C:\> CD(Paste the location from the address bar as shown in the option 2)
——————————————————–
C:\….\Python36-32> python.exe PyCDR.py “CDR Raw Report.txt” “Output.csv” 10000 >>> Execute this command
Once the command is executed, you will see a file “Output.csv” in the same folder that would have the CDR Records inside the fil
Sample Output
Hope this helps!
Originally posted 2017-06-03 12:46:31. Published by Team UC Collabing

I am working in an IT company and having 10+ years of experience into Cisco IP Telephony and Contact Center. I have worked on products like CUCM, CUC, UCCX, CME/CUE, IM&P, Voice Gateways, VG224, Gatekeepers, Attendant Console, Expressway, Mediasense, Asterisk etc. I am not an expert but i keep exploring whenever and wherever i can and share whatever i know. You can visit my LinkedIn profile by clicking on the icon below.
“Everyone you will ever meet knows something you don’t.” ― Bill Nye
3 thoughts on “Python Script to Extract Call Record from Cisco CDR”