Thursday, January 15, 2015

Python script to search Cisco CUCM Call Detail Records

If you manage Cisco CUCM and get requests for Call Detail Records, you know how frustrating it can be to have to:
  1. import the csv file to Excel
  2. delete out all but 4 of over 60 columns
  3. search thousands of rows of data to narrow down to the one extension
  4. convert epoch time to something a human understands
The first time I had to fulfill a request for call records, it took me most of the day to figure it out. Before I wrote this script it took me an average of a couple hours. That's two hours too long. With this script and Python installed, you can have a csv file to import into Excel in seconds.