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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide