I am trying to pull a CDR for a call handler that is built in Unity Connection. Does anyone know if there is a way to pull historical data on a number in CDR and export it cleanly into excel. I am not that familiar with CDR and I have a user that is requesting call volume on a number for the last year and CDR would be the only way I know how to gather that data.
You can search by phone number in CDR/CAR, but it's impossible to get information for a whole year, the maximum period of time CUCM will hold data for are 180 days (and that is assuming it has been configured to do so, and the volume of calls doesn't cause the records to overwrite before 180 days, or whatever your current setting is).
The only way to get a report for a whole year, is if you exported the CDR flat files to an external location, and process them there to get the data.
Another, likely easier way would be to get a 3rd party call reporting server. If you go down that road, check out VoIP Detective. There is a free forever version that reports on the previous 7 days, or a paid version that has no data retention limit.
Learn: How to configure Cloud Connected PSTN with Webex Calling
CCP Provider Name
Product Home Page Link
Webex Calling Customer Region
Countries Supported by Provider
Free Trial Link
Contact Provider Link
FR & LU
Meet the Authors Video - Leveraging SBCs to Empower a Changing World of Collaboration
(Live event – Tuesday, 16th, 2020 at 10:00 a.m. Pacific / 1:00 p.m. Eastern / 7:00 p.m. Paris)
This event had place on Tuesday 16th, February 2020 at 10am PST ...
This event had place on Tuesday 16th, February at 9:30am PST
The need for virtual collaboration across individuals, teams, organizations, and industries has been significantly changed with the global challenges presented in 2020. The indust...
Cisco Champion Radio · S8|E8 The Future of Work with Cognitive Collaboration
Cognitive Collaboration brings together intelligence and context throughout all collaboration experiences. Bridging AI and ML capabilities with insight and the context of the me...