CDR analysis and reporting output translation

Unanswered Question
Sep 23rd, 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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Jaime Valencia Thu, 09/23/2010 - 12:11

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)

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



If this helps, please rate

Rob Pyke Thu, 09/23/2010 - 12:36

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.


This Discussion