×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

SRST CDR

Unanswered Question
Jun 29th, 2008
User Badges:

Experts,


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?


Thanks in advance.


Regards,

Nic



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
Loading.
Michael Owuor Sun, 06/29/2008 - 20:08
User Badges:
  • Cisco Employee,

Hi Nic,


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.


http://www.cisco.com/en/US/prod/collateral/voicesw/ps6788/vcallcon/ps2169/prod_qas0900aecd8028d113.html


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:


- http://www.mindcti.com/

- http://isi-info.com/


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."


This feature is documented here:

http://www.cisco.com/en/US/docs/ios/voice/vsa/feature/guide/itfileac.html


Hope this helps.


Regards,

Michael.

nicholas80 Tue, 07/01/2008 - 20:19
User Badges:

Hi Michael,


I just wondering whether the call records in a .csv file format generated in ISR router will be the same format with those generated in CUCM?


Regards,

Nicholas

webstd.design Tue, 07/01/2008 - 23:58
User Badges:

And what is the mechanism for importing CDR data from router to the CCM?

Michael Owuor Wed, 07/02/2008 - 06:05
User Badges:
  • Cisco Employee,

Nic,


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.


Hope this helps.


Michael.

nicholas80 Tue, 07/08/2008 - 17:49
User Badges:

Hi,


Does anyone has a sample of .csv generated from the SRST router? I need the data for testing on our billing server.


Regards,

Nicholas

sangin079 Sun, 02/13/2011 - 03:56
User Badges:

Hello,


I have a question.


When SRST mode, does Voice Gateway can generates CDR it's flash?


and if Voice Gateway can communicates with CUCM, Voice gateway can send it's CDR to billing server or any other thing?


also I can't open web link.


please write another accurate web address.


Regards..

Actions

This Discussion