cdrRecordType
|
0,
1, or 2
|
This field specifies the type of this specific record. The
following valid values apply:
- 0—Start call detail record
(not used)
- 1—End call detail record
- 2—CMR record
Default - For CMRs, this field always specifies 2.
|
globalCallID_callManagerId
|
Positive Integer
|
This field specifies a unique
Cisco Unified Communications
Manager identity.
This field makes up 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.
Default - Ensure this field always is populated.
|
globalCallId_callId
|
Positive Integer
|
This field specifies a unique call identity value that gets
assigned to each call. The system allocates this identifier independently on
each call server. Values get chosen sequentially when a call begins. Each call,
successful or unsuccessful, receives value assignment.
This field makes up half 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.
Default - Ensure this field always is populated.
|
nodeId
|
Positive Integer
|
This field specifies the server, or node within the
Cisco Unified Communications
Manager cluster, where this record gets generated.
Default - Ensure this field always is populated.
|
directoryNumber
|
Integer
|
This field specifies the directory number of the device from
which these diagnostics are collected.
Default - Ensure this field always is populated.
|
callIdentifier
|
Positive Integer
|
This field identifies the call leg to which this record
pertains.
Default - Ensure this field always is populated.
|
dateTimeStamp
|
Integer
|
This field represents the approximate time that the device goes
on hook.
Cisco Unified Communications
Manager records the time when the phone responds to a request for
diagnostic information.
Default - Ensure this field always is populated.
|
numberPacketsSent
|
Integer
|
This field designates the total number of Routing Table Protocol
(RTP) data packets that the device transmits since starting transmission on
this connection. The value remains zero if the connection is set to
"receive
only" mode.
Default - 0
|
numberOctetsSent
|
Integer
|
This field specifies the total number of payload octets (that
is, not including header or padding) that the device transmits in RTP data
packets since starting transmission on this connection. The value remains zero
if the connection is set to
"receive
only" mode.
Default - 0
|
numberPacketsReceived
|
Integer
|
This field specifies the total number of RTP data packets that
the device has received since starting reception on this connection. The count
includes packets that are received from different sources if this is a
multicast call. The value remains zero if the connection is set in
"send
only" mode.
Default - 0
|
numberOctetsReceived
|
Integer
|
This field specifies the total number of payload octets (that
is, not including header or padding) that the device has received in RTP data
packets since starting reception on this connection. The count includes packets
that are received from different sources if this is a multicast call. The value
remains zero if the connection is set in
"send
only" mode.
Default - 0
|
numberPacketsLost
|
Integer
|
This field designates the total number of RTP data packets that
have been lost since the beginning of reception. This number designates the
number of packets that were expected, less the number of packets that were
actually received, where the number of packets that were received includes any
that are late or duplicates. Thus, packets that arrive late do not get counted
as lost, and the loss may be negative if duplicate packets exist. The number of
packets that are expected designates the extended last sequence number that was
received, as defined next, less the initial sequence number that was received.
The value remains zero if the connection was set in
"send
only" mode. For detailed information, see RFC 1889.
Default - 0
|
jitter
|
Integer
|
This field provides an estimate of the statistical variance of
the RTP data packet interarrival time, measured in milliseconds and expressed
as an unsigned integer. The interarrival jitter J specifies the mean deviation
(smoothed absolute value) of the difference D in packet spacing at the
receiver, compared to the sender for a pair of packets. RFC 1889 contains
detailed computation algorithms. The value remains zero if the connection was
set in
"send
only" mode.
Default - 0
|
latency
|
Integer
|
This field designates value that is an estimate of the network
latency, expressed in milliseconds. This value represents the average value of
the difference between the NTP timestamp that the RTP Control Protocol (RTCP)
messages indicates and the NTP timestamp of the receivers, measured when these
messages are received.
Cisco Unified
Communications Manager obtains the average by summing all estimates
then dividing by the number of RTCP messages that have been received. For
detailed information, see RFC 1889.
Default - 0
Note
|
CMR
records will not show latency for all phone loads. For example, for SIP 9.2.1
and 9.2.2, the latency will not show, as it has not been implemented in these
loads.
|
|
pkid
|
Text String
|
This field identifies a text string that the database uses
internally to uniquely identify each row. This text string provides no meaning
to the call itself.
Default - The system always populates this field with a unique
ID.
|
directoryNumberPartition
|
Text String
|
This field identifies the partition of the directory number.
Default - Empty string,
"". This field may
remain empty if no partition exists.
|
globalCallId_ClusterId
|
Text String
|
This field designates a unique ID that identifies a single
Cisco Unified
Communications Manager, or a cluster of
Cisco Unified
Communications Managers.
The system generates this field during installation, but
Cisco Unified
Communications Manager does not use it: globalCallId_ClusterId +
globalCallId_callManagerId + globalCallId_callId.
Default - Ensure this field always is populated.
|
deviceName
|
Text String
|
This field identifies the name of the device.
Default - Empty string
"". This field may
remain empty if no device name exists.
|
varVQMetrics
|
Text String
|
This field contains a variable number of voice quality metrics.
This field comprises a string of voice quality metrics that are separated by a
semicolon.
The format of the string follows:
fieldName=value;fieldName=value.precision
This example shows voice quality data, but the names may differ.
"MLQK=4.5000;MLQKav=4.5000;
MLQKmn=4.5000;MLQKmx=4.5000;MLQKvr=0.95; CCR=0.0000;ICR=0.0000;ICRmx=0.0000;
CS=0;SCS=0”
Note
|
See
topics related to K-factor data stored in
Cisco Unified Communications Manager CMRs for a
complete list of K-Factor data.
|
|
duration
|
Integer
|
This value
is the duration of audio session, expressed in seconds. This is reported only
for SIP phones.
|
videoContentType
|
Text
String
|
Identifies
the type of video stream. It can be “main”, “speaker” or “slides”. For an
audio-only call, no video metrics will be populated.
|
videoDuration
|
Integer
|
This value
is the duration of the first video session, expressed in seconds.
|
numberVideoPacketsSent
|
Integer
|
The total
number of RTP data packets transmitted by the device since starting
transmission on this connection.
|
numberVideoOctetsSent
|
Integer
|
The total
number of payload octets (that is, not including header or padding) transmitted
in RTP data packets by the device since starting transmission on this
connection.
|
numberVideoPacketsReceived
|
Integer
|
The total
number of RTP data packets received by the device since starting reception on
this connection.
|
numberVideoOctetsReceived
|
Integer
|
The total
number of payload octets (that is, not including header or padding) received in
RTP data packets by the device since starting reception on this connection.
|
numberVideoPacketsLost
|
Integer
|
The total
number of RTP data packets that have been lost since the beginning of reception
on this connection.
|
videoAverageJitter
|
Integer
|
This is an
estimate of the statistical variance of the RTP data packet interarrival time
for this connection, measured in milliseconds and expressed as an unsigned
integer. For detailed information, see RFC 3550 for details.
|
videoRoundTripTime
|
Integer
|
This is a
measure of average round trip time between the two endpoints for this
connection. It is expressed in milliseconds. For detailed information, see RFC
3550 and RFC 3611 for detail
|
videoOneWayDelay
|
Text
String
|
This is a
measure of the average one way delay (OWD) between the endpoints for this
connection. This is only available if endpoints are time synchronized (same NTP
source) and is measured in milli-seconds; otherwise “NA”
|
videoTransmissionMetrics
|
Text
String
|
This field
contains a variable number of Cisco defined metrics related to RTP transmission
on this connection. These metrics are delimited by a semi-colon. The format of
this string is:
CiscoTxVM="TxCodec=xxx; TxBw=xxx;TxBwMax=xxx;
TxReso=xxx;TxFrameRate=xxx"
TxCodec
identifies the type of video codec used for transmitted video stream.
TxBw
identifies the actual bandwidth used for the transmitted video stream.
TxBwMax
identifies the maximum negotiated bandwidth for the transmitted video stream.
TxReso
identifies the resolution of the transmitted video stream (for example,
640x480).
TxFrameRate identifies the average frame rate measured in frames
per second for the transmitted video stream.
|
videoReceptionMetrics
|
TextString
|
This field
contains a variable number of Cisco defined metrics related to RTP reception on
this connection. These metrics are delimited by a semi-colon. The format of
this string is:
CiscoRxVM="CS=xxx; SCS=xxx;DSCP=xxx; DSCPunad=xxx;
RxFramesLost=xxx;RxCodec=xxx; RxBw=xxx;RxBwMax=xxx; RxReso=xxx;RxFrameRate=xxx"
CS
identifies the concealed seconds metrics for the received video stream.
SCS
identifies the severely concealed seconds for the received video stream.
DSCP is
useful in verifying the DSCP value of the received video stream marked by
endpoint.
DSCPunad
is useful in verifying the DSCP value of the received video stream marked by
endpoint.
RxCodec
identifies the type of video codec used for received video stream.
RxBw
identifies the actual bandwidth used for the received video stream.
RxBwMax
identifies the maximum negotiated bandwidth for the received video stream.
RxReso
identifies the resolution of the received video stream (for example, 640x480).
RxFrameRate identifies the average frame rate measured in frames
per second for the received video stream.
|
videoContentType_channel2
|
Text
String
|
Identifies
the type of second video stream if it exists. If it does not exist, the
remaining metrics for the second video stream will not be populated.
|
videoDuration_channel2
|
Integer
|
The
duration of the second video session, expressed in seconds.
|
numberVideoPacketsSent_channel2
|
Integer
|
The total
number of RTP data packets transmitted by the device since starting
transmission on this connection.
|
numberVideoOctetsSent_channel2
|
Integer
|
The total
number of payload octets (that is, not including header or padding) transmitted
in RTP data packets by the device since starting transmission on this
connection.
|
numberVideoPacketsReceived_channel2
|
Integer
|
The total
number of RTP data packets received by the device since starting reception on
this connection.
|
numberVideoOctetsReceived_channel2
|
Integer
|
The total
number of payload octets (that is, not including header or padding) received in
RTP data packets by the device since starting reception on this connection.
|
numberVideoPacketsLost_channel2
|
Integer
|
The total
number of RTP data packets that have been lost since the beginning of reception
on this connection.
|
videoAverageJitter_channel2
|
Integer
|
This is an
estimate of the statistical variance of the RTP data packet interarrival time
for this connection, measured in milliseconds and expressed as an unsigned
integer. For more information, see RFC 3550.
|
videoRoundTripTime_channel2
|
Integer
|
This is a
measure of average round trip time between the two endpoints for this
connection. It is expressed in milliseconds. For more information, see RFC 3550
and RFC 3611 for details.
|
videoOneWayDelay_channel2
|
Integer
|
This is a
measure of the average one way delay (OWD) between the endpoints for this
connection. This is only available if endpoints are time synchronized (same NTP
source) and is measured in milli-seconds; otherwise “NA”.
|
videoReceptionMetrics_channel2
|
Text
String
|
This field
contains a variable number of Cisco defined metrics related to RTP transmission
on this connection. These metrics are delimited by a semi-colon. The format of
this string is:
CiscoTxVM="TxCodec=xxx; TxBw=xxx ;TxBwMax=xxx;
TxReso=xxx;TxFrameRate=xxx"
TxCodec
identifies the type of video codec used for transmitted video stream.
TxBw
identifies the actual bandwidth used for the transmitted video stream.
TxBwMax
identifies the maximum negotiated bandwidth for the transmitted video stream.
TxReso
identifies the resolution of the transmitted video stream (for example,
640x480).
TxFrameRate identifies the average frame rate measured in frames
per second for the transmitted video stream.
|
videoTransmissionMetrics_channel2
|
Text
String
|
This field
contains a variable number of Cisco defined metrics related to RTP reception on
this connection. These metrics are delimited by a semi-colon. The format of
this string is:
CiscoRxVM="CS=xxx; SCS=xxx;DSCP=xxx; DSCPunad=xxx;
RxFramesLost=xxx;RxCodec=xxx; RxBw=xxx;RxBwMax=xxx; RxReso=xxx;RxFrameRate=xxx"
CS
identifies the concealed seconds metrics for the received video stream.
SCS
identifies the severely concealed seconds for the received video stream.
DSCP is
useful in verifying the DSCP value of the received video stream marked by
endpoint.
DSCPunad
is useful in verifying the DSCP value of the received video stream marked by
endpoint.
RxCodec
identifies the type of video codec used for received video stream.
RxBw
identifies the actual bandwidth used for the received video stream.
RxBwMax
identifies the maximum negotiated bandwidth for the received video stream.
RxReso
identifies the resolution of the received video stream (for example, 640x480).
RxFrameRate identifies the average frame rate measured in frames
per second for the received video stream.
|