Table Of Contents
Cisco CallManager 4.0(1) Call Detail Record Definition
Cisco CallManager Release 4.0(1)
Cisco CallManager CDR Overview
Cisco CallManager Configuration
Cisco IP Phone Failure During a Call
Immediate Divert (to Voicemail)
Interpreting Cisco Personal Assistant Data in the CDRs
Personal Assistant Direct Call
Personal Assistant Interceptor Going to Media Port and Transferring the Call
Personal Assistant Interceptor Going Directly to Destination
Personal Assistant Going Directly to Destination With No Rules
Personal Assistant Direct Multiple Destinations: 2110 and 2120 (Call Accepted at First Destination)
Personal Assistant Direct Multiple Destinations: 2110 and 2120 (Call Accepted at Second Destination)
Personal Assistant Direct Multiple Destinations: 2110 and 2120 (Call Accepted at Third Destination)
Personal Assistant Conferencing
Immediate Divert (IDivert) During Alerting
Obtaining Technical Assistance
Obtaining Additional Publications and Information
Cisco CallManager 4.0(1) Call Detail Record Definition
This document describes the format and logic of the call detail records (CDRs) that the Cisco CallManager Release 4.0(1) system generates. An integration partner can use this information for post-processing activities such as generating billing records and network analysis. This document describes how to access the database, how to interpret fields in the database schema, and some of the known issues.
When you install your system, the system specifies that Call Detail Records (CDRs) are disabled by default. You can enable and disable CDR records at any time while the system is in operation. You do not need to restart the Cisco CallManager for changes to take effect. The system responds to all changes within a few seconds.
Contents
This document covers the following topics:
•
Cisco CallManager CDR Overview
•
Cisco CallManager Configuration
•
CDR Record Field Descriptions
•
Interpreting Cisco Personal Assistant Data in the CDRs
•
Obtaining Technical Assistance
•
Obtaining Additional Publications and Information
New and Changed Information
This section describes any new features and or changes for CDRs that are pertinent to the specified release of Cisco CallManager.
Cisco CallManager Release 4.0(1)
The following list provides the features or changes for CDRs in Cisco CallManager release 4.0(1):
•
Identifies Multilevel Precedence and Preemption (MLPP)
–
Adds the new field
origPrecendenceLevelfor the precedence level of the originating leg of the call–
Adds the new field
destPrecedenceLvelfor the precedence level of the destination leg of the call–
MLPP utilizes existing cause codes 8, 9, 46, 50, and 128
•
Identifies malicious calls by adding a new
Commentfield•
Drop any party feature utilizes existing cause fields:
origCause_valueanddestCause_value•
OnBehalfOffield contains a new code (value = 14) for the Immediate Divert feature and value = 15 for Barge•
The following new fields support video in Cisco CallManager:
–
origVideoCap_Codec–
destVideoCap_Codec–
origVideoCap_Bandwidth–
destVideoCap_Bandwidth–
origVideoCap_Resolution–
destVideoCap_Resolution–
origVideoTransportAddress_IP–
origVideoTransportAddress_Port–
destVideoTransportAddress_IP–
destVideoTransportAddress_Port•
Adds user login fields (
callingPartyLoginUserIDandfinalCalledPartyLoginUserID) to ensure that a valid UserID is associated with a newly created phone device and properly reported in CDRs•
Adds CDRView Utility examples for different call scenarios including IDivert, Barge, and cBarge
Cisco CallManager Release 3.2
The change for CDRs in Cisco CallManager release 3.2 means that CDR records are written to comma-delimited flat files (text) on the subscriber databases. The localCDRPath service parameter specifies the directory to which the files are written. CDR and CMR records periodically pass from each subscriber to the publisher, and the CiscoInsertCDR service reads the records from the flat files and inserts the records into the centralized SQL database.
Cisco CallManager CDR Overview
The Cisco CallManager comprises several Windows 2000 Servers that are using Microsoft SQL clustering method to share common data. Each cluster comprises a publisher and several subscriber databases.
Microsoft SQL Server 2000 Service Pack 3A replaces Microsoft SQL 7.0 and is configured with only TCP for communications and NT authentication. Named Pipes communications and Mixed mode authentication are no longer configured.
Note
The system supports SQL Authentication although Windows NT Authentication is recommended.
The connection logic in the database layer changed to use Windows NT authentication. All database layer connections, which are DSN based, use an Open Database Connectivity (ODBC) system DSN, CiscoCallManager. For more information, see the "Reading Records" section.
Any third party application that connects to the database can change the way that it connects. Beyond that, everything else remains the same. Both previous and current connections work.
The configuration ensures that web applications that do not require an NT login and use the database layer, such as CCMUser, run as a different NT user with limited privileges, not ANONYMOUS.
Cisco CallManager generates two different types of call information records: Call Detail Records (CDRs) and Call Management Records (CMRs). The CDRs store information about the endpoints of the call and other call control/routing aspects. The CMRs contain information about the quality of the streamed audio of the call. More than one CMR can exist per CDR.
The CDR records relate to the CMR records via the two globalCallID columns:
•
globalCallID_callManagerId
•
globalCallID_callId
The primary server (publisher) maintains the central copy of the CDR database. When a call is generated on a subscriber, the Cisco CallManager writes CDRs and CMRs in flat files (text) on the subscriber databases. The localCDRPath service parameter specifies the directory to which the files are written. CDR and CMR records periodically pass from each of the subscribers to the publisher, and the CiscoInsertCDR service reads the records from the flat files and inserts the records into the centralized SQL database.
The configurable directory that contains the files defaults to \Program Files\Cisco\CallDetail.
Cisco CallManager does not perform any post processing on the records. For more information, see the "Writing Records" section.
Note
Each server (publishers and subscribers) can operate as a call-control engine, but Cisco recommends that you reserve the publisher server for management processes.
Cisco CallManager Configuration
Enable or disable the CDR and CMR records through the Cisco CallManager service parameters. You can find information on where and how the CDR and CMR records are generated in the System enterprise parameters.
Service Parameters
The Cisco CallManager contains the following service parameters, set to False by default, that control the generation of CDRs:
•
CdrEnabled—Enables or disables CDR records.
•
CdrLogCallsWithZeroDurationFlag—Enables logging of CDR records for calls that were never connected or that lasted less than 1 second. If you set this parameter to True, all calls get written to the database.
•
CallDiagnosticsEnabled—Enables or disables CMRs.
To view all CDRs for billing and fraud detection purposes, enable the flags.
The MaxCdrRecords service parameter controls the maximum number of CDRs on the system. When this limit is exceeded, the oldest CDRs automatically get removed, along with the related CMR records, once a day. The default value specifies 1.5 million records.
Note
Enable these configuration items separately on each server in a cluster.
You can configure service parameters on the Service Parameters Configuration window in the Cisco CallManager Administration.
Enterprise Parameters
Configure the following parameters in the Enterprise Parameters Configuration window in the Cisco CallManager Administration.
•
LocalCDRPath—The directory for local CDR files that Cisco CallManager writes. Ensure that the value is not empty or invalid, or the CDR files will not be moved.
•
PrimaryCDRUNCPath—The central collection point for CDR files. Ensure that the value is not empty or invalid, or the CDR files will not be moved. The install sets this parameter.
•
CDRFormat—The parameter that determines whether the files get inserted into the database. The value specifies either FLAT or DB(Default DB).
•
PrimaryCDRDSN—An optional parameter that points to the primary CDR server on which to insert CDRs. The machine, to which the parameter points, does not need a Cisco CallManager install but does need SQL server and a CDR database. This allows movement of the CDRs off the Cisco CallManager cluster. If this parameter is missing, CDRs get written locally at the PrimaryCDRUNCPath.
•
CDRFlatFileInterval—The parameter that determines the number of minutes to write to a CDR file before Cisco CallManager closes the CDR file and opens a new one.
Note
If the PrimaryCDRDSN parameter is missing, CDRs get written locally at the PrimaryCDRUNCPath.
Retaining the default values for these parameters will write CDRs to the primary CDR server database.
Global Call Identifier
The Cisco CallManager allocates a global call identifier (GlobalCallID) each time that a Cisco IP Phone is taken off hook or a call is received from a gateway.
The CDR table lists the CDRs that are written to the CDR table at the end of a call in the order that they are written. GlobalCallIDs for active calls do not appear in the CDR table. Other global IDs may not appear in the CDR table. For example, each call leg in a conference call gets assigned a GlobalCallID that the conference GlobalCallID overwrites. The original GlobalCallID does not appear in the CDR.
The following table contains a sample CDR:
GlobalCallID Start Time End Time1
973795815
973795820
2
973795840
973795845
5
973795860
973795870
4
973795850
973795880
The CDR table does not contain an entry for GlobalCallID 3 because that call was active when this record was taken. The table shows GlobalCallID 5 listed before GlobalCallId 4 because the GlobalCallID 5 call ended before GlobalCallID 4 ended, and therefore, only completed calls and failed calls get written to the CDR table.
Number Translations
The Cisco CallManager can perform translations on the digits that a user dials. The translated number, not the actual dialed digits, appears in the CDR.
For example, many companies translate "911" calls to "9-911," so the caller does not need to dial an outside line in an emergency. In these cases, the CDR contains "9911" even though the user dials "911."
Note
Gateways may perform further modifications to the number before the digits are actually output through the gateway. The CDR does not reflect these modifications.
Partitions and Numbers
Within a CDR, a combination of extension number and partition identifies each phone that is referenced, if partitions are defined. When partitions exist, fully identifying a phone requires both values because extension numbers may not be unique.
The Partition field stays empty when a call ingresses through a gateway. When a call egresses through a gateway, the Partition field shows the partition to which the gateway belongs.
If the dial plan allows callers to use the # key for speed dialing, the # key goes into the database when it is used. For example, the Called Party Number field may contain a value such as "902087569174#."
The CDR uses the following Partition/Extension Number:
Timestamps
Timestamps within a CDR record appear in universal coordinated time (UTC), which is the number of seconds since midnight on January 1, 1970. This value remains independent of daylight saving time changes.
Unsigned 32-bit integers represent all time values. This unsigned integer value displays from the database as a single integer. The field specifies a time_t value that is obtained from the Windows NT (2000) system routines.
The CDR includes the following timestamps:
Call Clearing Causes
The CDR record includes two clearing causes: OrigCause and DestCause. When the originating party clears the call, the OrigCause gets populated. When the terminating party clears the call, or the call is rejected, the DestCause gets populated. When unpopulated, the cause value shows zero.
The "Cause Codes" section lists the calls clearing cause values per ITU specification Q.850. For on-net call legs, the Cisco CallManager determines the cause value. For off-net call legs, the far-end switch determines the cause value.
IP Addresses
The system stores IP addresses as unsigned integers. The database displays them as signed integers. To convert the signed decimal value to an IP address, first convert the value to a hex number, taking into consideration that it is really an unsigned number. The 32-bit hex value represents four bytes in reverse order (Intel standard). To determine the IP address, reverse the order of the bytes and convert each byte to a decimal number. The resulting four bytes represent the four-byte fields of the IP address in dotted notation.
Note
The database displays a negative number when the low byte of the IP address has the most significant bit set.
For example, the IP address 192.168.18.188 displays as -1139627840. To convert this IP address, perform the following procedure:
Procedure
Step 1
Convert the database display (-1139627840) to a hex value.
The hex value equals 0xBC12A8C0.Step 2
Reverse the hex bytes, as shown below:
CO A8 12 BCStep 3
Convert the bytes from hex to decimal, as shown below:
192 168 18 188Step 4
The IP address displays in the following format:
192.168.18.188
Working with CDRs
Users can access the Microsoft SQL Server 2000 Service Pack 2 database via ODBC. The install configures an ODBC system DSN that is called CiscoCallManager. Users have read-only access to all tables in the database and have read/write access to the CDR and CMR tables.
When working with CDRs, you may want to read other tables in the database to obtain information about the type of device in each CDR. Because this correlation between devices in the Device table and the IP address that is listed in the CDR is not straightforward, it appears as a known issue in the "Known Issues" section.
Writing Records
The Cisco CallManager writes CDRs to the SQL database, as calls are made, in a manner consistent with the configuration of each individual Cisco CallManager. You can configure the Cisco CallManager by accessing Service Parameters Configuration in Cisco CallManager Administration.
When CDR records are enabled, Call Control generates one or more CDR records for each call. These records get sent to EnvProcessCdr, where they are written to the flat files. The number of records written varies by the type of call and significant changes that occur to the call, such as ending a call, transferring the call, redirecting the call, splitting, or joining a call.
When Diagnostics are enabled, processStationCdpc generates up to two CMR records for each call. Each type of call, such as conference calls, call transfers, forwarded calls, and calls through gateways, produce a set of records that get written to the database at the end of the call. Only completed calls and failed calls generate records.
Note
The Cisco CDR Insert service will not insert a record if the CDRFormat service parameter has a value of Flat. If the service is disabled on the local Cisco CallManager, the CDR files generate but do not get moved and deleted.
Reading Records
The easiest way to read data from the SQL database may be to use ODBC. The connection string looks like one of the following examples, depending on whether you need to get to the configuration data or CDRs:
For SQL authentication:
DRIVER={SQL Server};SERVER=machineX;DATABASE=CCM0300;UID=CiscoCCMUser;PWD=password
DRIVER={SQL Server};SERVER=machineX;DATABASE=CDR;UID=CiscoCCMCDR;PWD=password
For Windows NT authentication:
DSN=CiscoCallManager;SERVER=X;DATABASE=CCM0300;Trusted_Connection=yes
or
DSN=CiscoCallManager;SERVER=X;DATABASE=CDR;Trusted_Connection=yes
Use the correct database name. The tables reside in the CDR database.
Note
You need access to both the configuration database and CDR database to properly resolve the CDR information.
The machine that serves the primary CCM0300 database serves as the machine that is the central collector of the CDR information.
You can find the primary database (machine and name) that the cluster currently is using by opening Cisco CallManager Administration, choosing Help > About Cisco CallManager, and clicking the Details button. You can also check the registry on machines that host a database. Look at the registry key, \\HKEY_LOCAL_MACHINE\Software\Cisco Systems Inc.\DBL, for DBConnection0. This string item contains a connection string that includes the machine name and database name of the primary database.
The following table specifies the user ID and password that you should use when you access the Cisco CallManager database.
Database Tables SQL User ID Password CapabilityCDR
CallDetailRecord,
CallDetailRecordDiagnostic
CiscoCCMCDR
dipsy
Read/Write
CCM0300
All
CiscoCCMCDR
dipsy
Read only
Removing Records
Because the Cisco CallManager relies on third-party packages to process the CDR data, you should remove the CDR data after all packages finish with the data. Use the CiscoCCMCDR user to remove the records. The CiscoCCMCDR user designates the Microsoft SQL Server account that can be used to read/write to the CDR and CMR tables.
If CDRs accumulate to a configured maximum, the system removes the oldest CDRs along with related CMR records once a day. The default maximum specifies 1,500,000 CDRs.
When removing CDR data after analysis, be sure to remove all related CMR records also.
Tips
You should remove records more often than once a day or week in large systems. Queries to remove records consume CPU time and transaction log space relative to the size of the table: the smaller the table, the quicker your query.
CDR Record Field Descriptions
The following table defines all fields in the current CDR records.
Field Name Range of Values DescriptioncdrRecordType
0, 1, or 2
Defines the type of record. The following valid values apply:
•
0—Start call detail record (not used)
•
1—End call detail record
globalCallID_callManagerId
Positive Integer
Designates unique Cisco CallManager identity.
This field comprises half of the Global Call ID. The Global Call ID comprises the following fields:
•
globalCallID_callID
•
globalCallID_callManagerID
All records that are associated with a standard call have the same Global Call ID in them.
globalCallID_called
Positive Integer
Designates unique call identity value that is assigned to each call. Cisco CallManager allocates this identifier independently on each call server. Values get chosen sequentially when a call begins. A value assignment occurs for each call, successful or unsuccessful.
This field comprises half of the Global Call ID. The Global Call ID comprises the following two fields:
•
globalCallID_callID
•
globalCallID_callManagerID
All records that are associated with a standard call have the same Global Call ID in them.
origLegCallIdentifier
Positive Integer
Identifies the originating leg of a call with a value that is unique within a cluster. If the leg of a call persists across several sub-calls, and consequently several CDRs (as during a call transfer), this value remains constant.
dateTimeOrigination
Integer
Identifies the date and time when the user goes off hook or the date and time when the setup message is received for an incoming call. UTC specifies the time.
origNodeId
Positive Integer
Identifies the node within a cluster to which the originator of the call is registered at the time the call is made
origSpan
Positive Integer or Zero
For calls that originate at a gateway, identifies the port or span on the gateway where the call originated.
For gateways in which the span number is unknown, this field contains the call leg ID of the originator.
For calls that did not originate at a gateway, the value equals zero.
origIpAddr
Integer
Identifies the IP address of the device that originated the call signaling.
For Cisco IP Phones, this field specifies the address of the Cisco IP Phone.
For PSTN calls, this field specifies the address of the gateway.
For intercluster calls, this field specifies the address of the remote Cisco CallManager.
The "IP Addresses" section describes the IP address format.
origIpPort
Positive Integer
Identifies the IP port number that is associated with the OrigIpAddr field.
callingPartyNumber
Text String
Specifies numeric string of up to 25 characters.
For calls that originate at a Cisco IP Phone, this field shows the extension number of the line that is used.
For incoming calls, this field specifies the value that is received in the Calling Party Number field in the SETUP message. This field reflects any translations that were applied to the Calling Party Number before it arrives at the Cisco CallManager (such as translations at the gateway).
origCause_location
0 to 15
For clearing causes that are received over ISDN signaling links, specifies the Location field that is indicated in the ISDN release message. The "Cause Codes" section lists the valid values per Q.850.
For clearing causes created internally by the Cisco CallManager, this value equals zero.
origCause_value
0 to 128
For calls that the originating party cleared, reflects the reason for the clearance. The "Cause Codes" section lists the valid values per Q.850.
For calls that the terminating party cleared, this field specifies zero.
In addition to the standard values that are described in Q.850, when a call is placed on hold, the CDR terminates, and this field gets set to 126. This represents a proprietary value for this field.
MLPP uses the current cause codes:
•
8—"Preemption: Call is being preempted, circuit not reserved for reuse."
•
9—"Preemption: Call is being preempted, circuit reserved for reuse."
•
46—"Precedence call blocked: No preemptable circuit or called user is busy with a call of equal or higher precedence level."
•
50—"Requested facility not subscribed." Cisco CallManager never generates this cause value. If is is received from another network, the system "transits" this value, if applicable.
•
128—"Conference Drop Any Party." This cause code indicates when a call was dropped from a conference by the new feature "drop any party/drop last party."
origPrecedenceLevel
0 to 4
For MLPP, each call leg has a precedence level. This field represents the original legs precedence level.
•
Precedence 0 = FLASH OVERRIDE
•
Precedence 1 = FLASH
•
Precedence 2 = IMMEDIATE
•
Precedence 3 = PRIORITY
•
Precedence 4 = ROUTINE
origMediaTransportAddress_IP
Integer
Identifies the IP address of the device that originated the media for the call.
For Cisco IP Phones, this field specifies the address of the Cisco IP Phone.
For PSTN calls, this field specifies the address of the gateway.
For intercluster calls, this field specifies the address of the remote Cisco IP Phone.
The "IP Addresses" section describes the IP address format.
origMediaTransportAddress_Port
Positive Integer
Identifies the IP port number that is associated with the OrigMediaTransportAddress_IP field
origMediaCap_payloadCapability
0 to 15, 32 to 33, 80 to 84
Identifies the codec type that the originator used to transmit media. The following valid values descriptions apply:
•
0—Media transfer stage was not reached during the call.
•
1—Nonstandard Codec
•
2—G.711 A-Law 64K
•
3—G.711 A-Law 56K
•
4—G.711 mu-Law 64K
•
5—G.711 mu-Law 56K
•
6—G.722 64K
•
7—G.722 56K
•
8—G.722 48K
•
9—G.723.1
•
10—G.728
•
11—G.729
•
12—G.729AnnexA
•
13—Is11172AudioCap
•
14—Is13818AudioCap
•
15—G.729AnnexB
•
16—G.729 Annex AwAnnexB
•
18—GSM Full Rate
•
19—GSM Half Rate
•
20—GSM Enhanced Full Rate
•
25—Wideband 256K
•
32—Data 64k
•
33—Data 56k
•
80—GSM
•
81—ActiveVoice
•
82—G726_32K
•
83—G726_24K
•
84—G726_16K
origMediaCap_maxFramesPerPacket
Positive Integer or Zero
Identifies the number of milliseconds of data per packet that the originating party sent. This field, normally set to 10, 20, or 30 for G.729 or G.711 codecs, can store any nonzero value.
This field can remain zero if the media is never established.
origMediaCap_g723BitRate
0, 1, or 2
When the codec that the originating party used is G.723, indicates the data rate that was used. The following values apply:
•
1—5.3K
•
2—6.3K
When the codec is not G.723, this value equals zero.
origVideoCap_Codec
100 = H.261
101 = H.263
102 = Cisco Video Link
Identifies the codec type used by the originator to transmit video (H.261, H.263, and the Cisco Video Link.)
origVideoCap_Bandwidth
Positive Integer
Identifies the bandwidth measured in units of kbps.
origVideoCap_Resolution
1 = SQCIF
2 = QCIF
3 = CIF
4 = CIF4
5 = CIF16
Identifies the Video resolution.
origVideoTransportAddress_IP
Integer
Identifies the IP address of the device that originates the call.
origVideoTransportAddress_Port
Positive Integer
Identifies the video RTP port associated with the origVideoTransportAddress_IP field.
destLegIdentifier
Positive Integer
Identifies the terminating leg of a call. This field specifies unique values within a cluster. If the leg of a call persists across several sub-calls and, consequently, several CDRs (as during a call transfer), this value remains constant.
destNodeId
Positive Integer
Identifies the node within a cluster to which the terminating party of the call is registered at the time that the call is made.
destSpan
Positive Integer or Zero
For calls that terminate at a gateway, identifies the port or span on the gateway where the call terminated.
For H.323 gateways in which the span number is unknown, this field contains the call leg ID of the destination.
For calls that did not terminate at a gateway, the value equals zero.
destIpAddr
Integer
Identifies the IP address of the device that terminated the call signaling.
For Cisco IP Phones, this field specifies the address of the Cisco IP Phone.
For PSTN calls, this field specifies the address of the gateway.
For intercluster calls, this field specifies the address of the remote Cisco CallManager.
The "IP Addresses" section describes the IP address format.
destIpPort
Positive Integer or Zero
Identifies the IP port number that is associated with the destIpAddr field.
originalCalledPartyNumber
Text String
Specifies numeric string of up to 25 characters.
This field specifies the number to which the original call was presented, prior to any call forwarding. If translation rules are configured on the Cisco CallManager, this number reflects the called number after the translations have been applied.
finalCalledPartyNumber
Text String
Specifies numeric string of up to 25 characters.
This field specifies the number to which the call is finally presented, until it is answered or ringsout. If no forwarding occurred, this number shows the same number as the OriginalCalledPartyNumber.
For calls to a conference bridge, this field contains the actual identifier of the conference bridge, which is an alphanumeric string (for example, "b0019901001").
destCause_location
0 to 15
For clearing causes that are received over ISDN signaling links, specifies the Location field that the ISDN release message indicates. The "Cause Codes" section lists the valid values per Q.850.
For clearing causes that the Cisco CallManager created internally, this value equals zero.
destCause_value
0 to 128
For calls that the destination party cleared, reflects the reason for the clearance. The "Cause Codes" section lists the valid values per Q.850.
For calls that the originating party cleared, this field equals zero.
MLPP uses the current cause codes:
•
8—"Preemption: Call is being preempted, circuit not reserved for reuse."
•
9—"Preemption: Call is being preempted, circuit reserved for reuse."
•
46—"Precedence call blocked: No preemptable circuit or called user is busy with a call of equal or higher precedence level."
•
50—"Requested facility not subscribed." Cisco CallManager never generates this cause value. If it is received from another network, the system "transmits" this value, if applicable.
•
128—"Conference Drop Any Party." This cause code indicates when a call was dropped from a conference by the new feature "drop any party/drop last party."
destPrecedenceLevel
0 to 4
For MLPP, each call leg has a precedence level. This field represents the destination legs precedence level.
•
Precedence 0 = FLASH OVERRIDE
•
Precedence 1 = FLASH
•
Precedence 2 = IMMEDIATE
•
Precedence 3 = PRIORITY
•
Precedence 4 = ROUTINE
destMediaTransportAddress_IP
Integer
Identifies the IP address of the device that terminated the media for the call.
For Cisco IP Phones, this field designates the address of the Cisco IP Phone.
For PSTN calls, this field designates the address of the H.323 gateway.
For intercluster calls, this field shows the address of the remote Cisco IP Phone.
The "IP Addresses" section describes the IP address format.
destMediaTransportAddress_Port
Positive Integer
Identifies the IP port number that is associated with the DestMediaTransportAddress_IP field.
destMediaCap_payloadCapability
0 to 15, 32 to 33, 80 to 84
Identifies the codec type that the terminating party used to transmit media.
The Codec Types section lists the valid values.
destMediaCap_maxFramesPerPacket
Positive Integer
Identifies the number of milliseconds of data per packet that the terminating party of the call sent. This field, normally set to 10, 20, or 30 for G.729 or G.711 codecs, can store any nonzero value.
This field can be zero if the media is never established.
destMediaCap_g723BitRate
0
Depreciated since Cisco CallManager Release 3.3(4).
destVideoCap_Codec
100 = H.261
101 = H.263
102 = Cisco Video Link
Identifies the codec type that the terminating party used to transmit video (H.261, H.263, and the Cisco Video Link).
destVideoCap_Bandwidth
Positive Integer
Identifies the bandwidth measured in units of kbps.
destVideoCap_Resolution
1 = SQCIF
2 = QCIF
3 = CIF
4 = CIF4
5 = CIF16
Identifies the video resolution.
destVideoTransportAddress _IP
Integer
Identifies the IP address of the device that receives the call.
destVideoTransportAddress_Port
Positive Integer
Identifies the video RTP port that is associated with the destVideoTransportAddress_IP field.
dateTimeConnect
Integer or Zero
Identifies the date and time that the call connected. UTC specifies the time. If the call is never answered, this value shows zero.
dateTimeDisconnect
Integer
Identifies the date and time when the call was cleared. This field gets set even if the call never connected. UTC specifies the time.
lastRedirectDn
Text String
Specifies numeric string of up to 25 characters.
For forwarded calls, this field specifies the phone number of the next to last hop before the call reaches its final destination. If only one hop occurs, this number matches the OriginalCalledPartyNumber.
For calls that are not forwarded, this field matches the OriginalCalledPartyNumber and the FinalCalledPartyNumber.
For calls to a conference bridge, this field contains the actual identifier of the conference bridge, which is an alphanumeric string (for example, "b0019901001").
pkid
Text String
Identifies a text string that the database uses internally to uniquely identify each row. This text string provides no meaning to the call itself.
originalCalledPartyNumberPartition
Text String
Identifies the partition name associated with the OriginalCalledPartyNumber field. This field uniquely identifies this number because the Cisco CallManager supports multiple Cisco IP Phones with the same extension number in different partitions. For calls that egress through a gateway, this field specifies the partition name that is associated with the route pattern that pointed to the gateway.
callingPartyNumberPartition
Text String
Identifies the partition name that is associated with the CallingPartyNumber field. This field uniquely identifies this number because the Cisco CallManager supports multiple Cisco IP Phones with the same extension number in different partitions. For calls that ingress through a gateway, this field remains blank.
finalCalledPartyNumberPartition
Text String
Identifies the partition name that is associated with the FinalCalledPartyNumber field. This field uniquely identifies this number because the Cisco CallManager supports multiple Cisco IP Phones with the same extension number in different partitions. For calls that egress through an H.323 gateway, this field specifies the partition name that is associated with the route pattern that pointed to the gateway.
lastRedirectDnPartition
Text String
Identifies the partition name that is associated with the LastRedirectDn field. This field uniquely identifies this number because the Cisco CallManager supports multiple Cisco IP Phones with the same extension number in different partitions. For calls that egress through an H.323 gateway, this field specifies the partition name that is associated with the route pattern that pointed to the gateway.
duration
Positive Integer or Zero
Identifies the difference between the Connect Time and Disconnect Time. This field specifies the time that the call remains connected, in seconds. This field remains zero if the call never connected or connected for less than 1 second.
origDeviceName
Text String
Specifies text string that identifies the name of the originating device.
destDeviceName
Text String
Specifies text string that identifies the name of the destination device.
origCalledPartyRedirectReason
Integer
Identifies the reason for a redirect of the original called party.
See the "Redirect Reason Codes" section for a complete list of the codes.
lastRedirectRedirectReason
Integer
Identifies the last redirect reason for redirection.
See the "Redirect Reason Codes" section for a complete list of the codes.
destConversationID
Integer
Specifies unique identifier that is used to identify the parties of a conference call.
origCallTerminationOnBehalfOf
Integer
Specifies code that identifies why the originator was terminated.
For example, if the originator of the call hangs up the phone, the OnBehalfOf code shows "12" for Device. If the call is terminated because of a transfer, the OnBehalfOf code shows "10."
See the "OnBehalfCodes" section for a complete list of the codes.
destCallTerminationOnBehalfOf
Integer
Specifies code that identifies why the destination was terminated.
For example, if the originator of the call hangs up the phone, the OnBehalfOf code shows "12" for Device. If the call is terminated because of a transfer, the OnBehalfOf code shows "10."
See the "OnBehalfCodes" section for a complete list of the codes.
origCalledPartyRedirectOnBehalfOf
Integer
Specifies code that identifies the reason for redirection of the original called party.
For example, if the original called party was redirected because of a conference, the OnBehalfOf code specifies "4."
See the "OnBehalfCodes" section for a complete list of the codes.
lastRedirectRedirectOnBehalfOf
Integer
Specifies code that identifies the reason for redirection of the last redirected party.
For example, if the last redirected party was redirected on behalf of a conference, the OnBehalfOf code specifies "4."
See the "OnBehalfCodes" section for a complete list of the codes.
joinOnBehalfOf
Integer
Specifies code that identifies the reason for a join.
For example, if the join took place on behalf of a transfer, the OnBehalfOf code specifies "10."
See the "OnBehalfCodes" section for a complete list of the codes.
globalCallId_ClusterId
Text String
Specifies a unique ID that identifies a cluster of Cisco CallManagers.
Cisco CallManager does not use this field that generates at installation. The following fields make up this unique key:
GlobalCallId_ClusterId + GlobalCallId_CMId + GlobalCallId_CallId
Comment
TextString
This field allows features to add text to the CDR records. This text can describe details about the call.
For example, the following field flags malicious calls.
Tag—CallFlag
Value—MALICIOUS
callingPartyLoginUserID
Text String
Identifies the calling party user login ID.
finalCalledPartyLoginUserID
Text String
Identifies the final called party user login ID.
CMR Fields (Diagnostic)
The following table contains the fields, range of values, and field descriptions of the CMRs.
Codec Types
The following table contains the compression and payload types that may appear in the codec fields.
Cause Codes
The following table contains cause codes that may appear in the Cause fields.


