Call reporting

Answered Question
Feb 12th, 2010
User Badges:

I'm looking for a solution to either dump call manager call record data directly to SQL or some way to extract data from call manager 7.  I have looked around the forums and can't seem to find a definitive answer.


Thanks!

Correct Answer by William Bell about 7 years 3 months ago

The CUCM CDR process is not going to be able to support a direct data dump to SQL.  Your best option is to stand up a server to receive CDR records from the CUCM cluster.  You would need to run FTP or SFTP on the server (I recommend SFTP) and then add the server as a billing server on the CUCM cluster (Tools->CDR Management) under the CUCM Serviceability page.


Once you have this done, I recommend setting the "CDR File Interval" parameter under Enterprise Parameters to something like 60.  This parameter specifies the time interval (in minutes) that the CDR repository service on CUCM collects CDRs and sends them to the billing server.   Getting 1,440 files in a 24 hour period (using the default CDR File Interval) may not be desirable.


Once you set this up you will start receiving the flat files which contain the calls.  Each record in the file is a CSV delimited record.  The first line of the file gives you the record headers.  You could then develop some routine that parses the CDRs and pushes them into your SQL table.



HTH.


Regards,
Bill

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Correct Answer
William Bell Fri, 02/12/2010 - 14:29
User Badges:
  • Purple, 4500 points or more

The CUCM CDR process is not going to be able to support a direct data dump to SQL.  Your best option is to stand up a server to receive CDR records from the CUCM cluster.  You would need to run FTP or SFTP on the server (I recommend SFTP) and then add the server as a billing server on the CUCM cluster (Tools->CDR Management) under the CUCM Serviceability page.


Once you have this done, I recommend setting the "CDR File Interval" parameter under Enterprise Parameters to something like 60.  This parameter specifies the time interval (in minutes) that the CDR repository service on CUCM collects CDRs and sends them to the billing server.   Getting 1,440 files in a 24 hour period (using the default CDR File Interval) may not be desirable.


Once you set this up you will start receiving the flat files which contain the calls.  Each record in the file is a CSV delimited record.  The first line of the file gives you the record headers.  You could then develop some routine that parses the CDRs and pushes them into your SQL table.



HTH.


Regards,
Bill

Actions

This Discussion

Related Content