CDR analysis and reporting output translation

Rob Pyke · ‎09-23-2010

Is there an easy was to translate CDR data into something easily understood?

I had to pull the to/from call records for a particular extension during a certain month long time frame and parse it by hand in excel to clean it up sorted by date/time so that a non technical staff member could understand it without me translating. Some one suggested Cisco VLT but I don't think it's for this kind of data

Jaime Valencia · ‎09-23-2010

I assume you mean you got CDR flat files, VLT is not for that. It's for CUCM traces.

You can use CAR to create reports.

You don't mention version so I'll provide the latest one:

Cisco Unified CDR Analysis and Reporting Administration Guide, Release 8.0(2)

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_0_2/car/CAR.html

You can buy a 3rd party billing server that can process the flat files and provide reporting.

Another option would be to write down your own program to do this, field definition is here:

Cisco Call Detail Records Field Descriptions

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_0_2/cdrdef/cdrfdes.html

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

HTH

java

if this helps, please rate

Rob Pyke · ‎09-23-2010

I am using CAR to create reports.

CDR -> Search ->by usernam/extension.

I'm specifying a single DN and time frame. I use the send function to email the file to myself. The output is a .txt file that to anyone else but me is confusing. Even placed in Excel it is tedious to parse the data for what the user needs much less make it readable to a non tech person.

Rob Pyke · ‎09-23-2010

I forgot to mention that it's CUCM Ver 7