09-23-2010 11:54 AM - edited 03-19-2019 01:38 AM
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
09-23-2010 12:11 PM
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:
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:
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
09-23-2010 12:36 PM
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.
09-23-2010 03:17 PM
I forgot to mention that it's CUCM Ver 7
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: