CDR data

Unanswered Question
Mar 26th, 2007
User Badges:

We need reports from the CDR data that shows basic info: extension, date,time, length of call, incoming - calling number,outgoing - called number. In a format that we can print and give to management. Any suggestions?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (3 ratings)
Loading.
Tommer Catlin Mon, 03/26/2007 - 10:58
User Badges:
  • Green, 3000 points or more

There are many third party vendors that will pull data from CCM CDR and organize based on your needs. The data in CCM CDR is fairly raw and not quite as customizable. If you wanted to search on extension, and pull up there calls, you can.... but trying to do by departments, etc.


Unless you are a whiz at SQL, you could query the items you need and build your own.


Software

WinCall

CommView

vvxtracker


if you search the forum also, you may find some others. I think Cisco has a few recommended partners.


good luck

jalston45 Mon, 03/26/2007 - 12:34
User Badges:

I used what already came with our CCM4.0 CDR reports and put them in a speadsheet. However it was a report for just one user, but it had all the info your asking about. I looked at querrying it in SQL but that wasn't as easy.

Tommer Catlin Mon, 03/26/2007 - 12:41
User Badges:
  • Green, 3000 points or more

The systems mentioned above, this things can email a report out to the manager you want automatically. They are even web based so the manager can login and view the report or extension list in their group.


If this is time consuming what you are doing now, and you have a large IPT base, I would spend the $20k and get into a CDR system.

walidazab Wed, 05/16/2007 - 03:55
User Badges:

Hi maryclegg ,


If you would like I have a commercial software that I wrote that does just exactly what you want. It is not for free though. You can contact me off the forum for further details if you wish.


Regards..

WindwardAdmin Tue, 05/22/2007 - 09:17
User Badges:

I have searched many places on the internet and have found that Wincall is a good solution but is expensive. Does anyone know of any other programs that can extract CDR data from a Cisco 2800 router with a CME module? If I could get the information in an XML file format that would be great because I have a reporting software that can use XML files to build reports. Any advice is welcome.


--Ryan Fligg

Actions

This Discussion