Troubleshooting guide

3-118
Cisco PGW 2200 Softswitch Release 9.8 Operations, Maintenance, and Troubleshooting Guide
OL-0800-14
Chapter 3 Cisco PGW 2200 Softswitch Platform Operations
Regular Operations
set-thres::cat="SIP: RETX MSG TOT",interval=1800, thres=125
Managing Call Detail Records
CDRs contain call billing records for your system. The Cisco PGW 2200 Softswitch stores the CDRs in
log files. For more information on log files, see Appendix A, “Configuring Cisco PGW 2200 Softswitch
Log Files.” For more information on CDRs, see Cisco PGW 2200 Softswitch Release 9 Billing Interface
Guide.
The following sections present procedures for managing CDR log files:
• Converting Individual CDR Files to ASCII Format, page 3-118
• Converting Individual CDR Files to a Readable Format, page 3-118
Converting Individual CDR Files to ASCII Format
You can convert individual CDR log files from their binary storage format to a comma-separated-value
(CSV) format by entering the following UNIX command at the active Cisco PGW 2200 Softswitch:
MGC_Toolkit cdrconvert -input cdrlogfile -output filename -outformat 1 [-follow]
Where:
• cdrlogfile—Name of the CDR log file to convert, including the file path.
• filename—Name for the file that is output when this command executes, including the file path.
• -outformat 1—Specifies that the output file should be in CSV format.
• -follow—Used when you are converting the active CDR file. Processing of the active CDR file
continues as CDR logs are created in the active file. Processing stops when you enter Control-C.
To convert an archived CDR log file from binary format to CSV format, enter the following UNIX
command:
MGC_Toolkit cdrconvert -input /opt/CiscoMGC/var/spool/cdr_20011113100350_002172.bin
-output /tmp/cdr.csv -outformat 1
The output file stores the CDR log file data in a manner like the following:
1090,,1,2001/Nov/13 EST 10:3:50,0X0000000000000000,2001/Nov/13 10:3:50
,MGC-CDR-NODE-STRING 1100,,1,2001/Nov/13 EST 10:18:50,0X0000000000000000,2001/Nov/13 EST
10:18:50,2,MGC-CDR-NODE-STRING
Converting Individual CDR Files to a Readable Format
View the CDR results that are stored in the CDR log file using the CDR viewer that is included in the
Cisco MGC viewer toolkit. For more information on viewing CDR log files using the CDR viewer, see
the “Using the Call Detail Record Viewer” section on page 3-123.
Also convert the contents of individual CDR log files to a readable format using the following UNIX
command entered at the active Cisco PGW 2200 Softswitch:
MGC_Toolkit cdrconvert -input cdrlogfile -output filename -outformat 2 [-follow]
Where:
• cdrlogfile—Name of the CDR log file to convert, including the file path.