During a WAN failure, I will have a router configured with SRST for the remote phones. How can I export the CDR generated on SRST to the CUCM? Is this possible? Understand the CDR generated on SRST is a raw or rather a syslog message. Can anyone advice how to regenerated or recompute the raw data to a standard CDR data in order to be able to process by an external billing server? Any ready scripting that I can use?
Historically, the CDR data collected from the CME/SRST gateway has been either in syslog format or Radius records.
Here's a relevant question in the SRST FAQ:
Q. Is there a way to maintain Call Detail Recording (CDR) during SRST mode and synchronize records with Cisco Unified Communications Manager records?
A. The SRST router provides CDRs in two formats -- syslog and RADIUS. In both formats, you need an external server to collect the CDR records from the SRST router.
Cisco Unified Communications Manager is not designed to process the CDR records generated by the router during fallback. Calls that are placed through the PSTN receive billing information only by the PSTN billing system. You can use CiscoWorks Voice Manager to export the call history log to a file that can then be processed in CDR format. CDR records can also be logged onto a syslog or a RADIUS server.
Since the CDR in SRST cannot be imported into the CUCM CDR database, one option is use a third party call accounting product that can handle both CUCM and SRST CDR records. So to have accurate billing records you would store the RADIUS records locally, then upload to the third party call accounting solution to merge RADIUS with CCM records once the WAN is restored. Third party apps that may do this include:
A new innovation in IOS version 12.4(15)XY will allow you to be able to write the CDR records to local router flash files. Additionally, this new accounting method allows you to generate call records in a .csv file format in addition to RADIUS and syslog accounting formats.
The file accounting feature introduced in Cisco IOS Release 12.4(15)XY provides a method for capturing accounting records in comma separated value (.csv) format and storing the records to a file in internal flash or to an external FTP server. It expands gateway accounting support which also includes the AAA and syslog mechanisms of logging accounting information.
"The accounting process collects accounting data for each call leg created on a Cisco voice gateway. You can use this information for postprocessing activities such as generating billing records and network analysis. Cisco voice gateways capture accounting data in the form of call detail records (CDRs) containing attributes defined by Cisco. The gateway can send CDRs to a RADIUS server, syslog server, and with the new file method, to flash or an FTP server in .csv format."
There is no mechanism for importing CDR data from the SRST router to the CUCM. If the goal is to have accurate records that includes the duration when the router was in SRST mode, then your best bet is to use one of the third party call accounting products that collects and the data from both the SRST router and from CUCM. Products like the ones listed in the previous post have the sophistication to be able to merge the records from the two different sources and provide a contiguous accounting.
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...