How CDRs Are Processed
This chapter provides information on how CDRs are processed and contains the following topics:
Cisco Unified Communications Manager generates two different types of call information records: CDRs and CMRs. The CDR records store information about a call. The CMR records store information about the quality of the streamed audio of the call. The CDR records relate to the CMR records by way of two GlobalCallID columns: Global CallID callManagerId and GlobalCallID Called. Depending upon the call scenario, more than one CMR may exist for each CDR.
When Cisco Unified Communications Manager places or receives a call, the system generates a CDR record when the call terminates. The system writes the CDR to a flat file (text file). Inside the Cisco Unified Communications Manager, the Call Control process generates CDR records. The system writes records when significant changes occur to a given call, such as ending the call, transferring the call, redirecting the call, splitting the call, joining a call, and so forth.
When CDR records are enabled, Call Control generates one or more CDR records for each call. The system sends these records to EnvProcessCdr, where they are written to the flat files. The number of records that are written varies by type of call and the call scenario. When Diagnostics are enabled, the device generates CMR records for each call. The system writes one CMR record for each IP phone that is involved in the call or for each Media Gateway Control Protocol (MGCP) gateway. The system also sends these records to EnvProcessCdr where they get written to flat files.
The Cisco Unified Communications Manager generates CDR and CMR records but does not perform any post processing on the records. The system writes the records to comma-delimited flat files and periodically passes them to the CDR Repository. The CDR and CMR files represent a specific filename format within the flat file.
The following example shows the full format of the filename: tag_clusterId_nodeId_datetime_seqNumber
•tag—Identifies the type of file, either CDR or CMR.
•clusterId—Identifies the cluster or server where the Cisco Unified Communications Manager database resides.
•nodeId—Identifies the node
•datetime—UTC time in yyyymmddhhmm format
Two examples of the filenames follow:
Note For Cisco Unified Communications Manager Business Edition 5000 installations, the value assigned to the clusterId equals 01.
Flat File Format
The CDR and CMR flat files have the following format:
•Line 1—List of field names comma separated
•Line 2—List of field type comma separated
•Line 3—Data comma separated
•Line 4—Data comma separated
The following example shows a flat file:
Note If the value of the CDR Log Calls With Zero Duration Flag parameter is True, the system writes all calls to a flat file. See the "Configuring CDR Service Parameters" section in the CDR Analysis and Reporting Administration Guide for additional information about this parameter.
•Chapter 1 "Understanding Cisco Call Detail Records"
•Chapter 3 "Types of Call Information Records"
•Chapter 8 "Cisco Call Management Records Field Descriptions."
The following documents contain additional information related to CDRs:
•CDR Analysis and Reporting Administration Guide
•Cisco Unified Serviceability Administration Guide