02-12-2010 01:14 PM - edited 03-15-2019 09:24 PM
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!
Solved! Go to Solution.
02-12-2010 02:29 PM
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
Please remember to rate helpful responses and identify
02-12-2010 02:29 PM
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
Please remember to rate helpful responses and identify
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