If you manage Cisco CUCM and get requests for Call Detail Records, you know how frustrating it can be to have to:
- import the csv file to Excel
- delete out all but 4 of over 60 columns
- search thousands of rows of data to narrow down to the one extension
- 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.