Cisco Unified Communications Manager CDR Analysis and Reporting Administration Guide for Cisco Unified Communications Manager, Release 6.0(1)
CAR Report Results
Downloads: This chapterpdf (PDF - 1.33MB) The complete bookPDF (PDF - 3.65MB) | Feedback

CAR Report Results

Table Of Contents

CAR Report Results

Bill Summary Report Results

Bill Detail Report Results

Top N By Charge or Duration Report Results

Top N By Number of Calls Report Results

Call Usage for Assistant—Detail Report Results

Call Usage for Assistant—Summary Report Results

Call Usage for Manager—Detail Report Results

Call Usage for Manager—Summary Report Results

Cisco IP Phone Services Report Results

QoS Detail Report Results

QoS Summary Report Results

QoS by Gateways Report Results

QoS by Call Types Report Results

Traffic Summary Report Results

Authorization Code Name Call Details Report Results

Authorization Level Call Details Report Results

Client Matter Code Details Report Results

Malicious Call Details Report Results

Precedence Call Summary Report Results

System Overview Report Results

CDR Error Report Results

Gateway Detail Report Results

Gateway Summary Report Results

Gateway and Route Utilization Report Results

Conference Call Detail Report Results

Conference Bridge Utilization Report Results

Voice Messaging Utilization Report Results

Understanding the CDR Search Results

Understanding the Results for CDR Search

Media Information

CDR and CMR Dump Tables


CAR Report Results



Tip When a logged-in Cisco Extension Mobility user makes a call, CAR uses the user ID that is configured for the Cisco Extension Mobility user in all reports that display a user ID. When the call is made by a non-Cisco Extension Mobility user (or logged-out Cisco Extension Mobility user) or when the call is made with a device that does not have a configured Owner User ID, CAR uses the default user ID, _unspecifieduser, in the report.


This chapter describes report output information for each CAR report type:

Bill Summary Report Results

Bill Detail Report Results

Top N By Charge or Duration Report Results

Top N By Number of Calls Report Results

Call Usage for Assistant—Detail Report Results

Call Usage for Assistant—Summary Report Results

Call Usage for Manager—Detail Report Results

Call Usage for Manager—Summary Report Results

Cisco IP Phone Services Report Results

QoS Detail Report Results

QoS Summary Report Results

QoS by Gateways Report Results

QoS by Call Types Report Results

Traffic Summary Report Results

Authorization Code Name Call Details Report Results

Authorization Level Call Details Report Results

Client Matter Code Details Report Results

Malicious Call Details Report Results

Precedence Call Summary Report Results

System Overview Report Results

CDR Error Report Results

Gateway Detail Report Results

Gateway Summary Report Results

Gateway and Route Utilization Report Results

Conference Call Detail Report Results

Conference Bridge Utilization Report Results

Voice Messaging Utilization Report Results

Understanding the CDR Search Results

Bill Summary Report Results

The report groups information by the user name in ascending order. The summary report includes the following fields (see Table 11-1).

Table 11-1 Summary Report Fields 

Field
Description

Call Classification—Call categories specify classes.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or that include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.

QOS—The number of calls for each Quality of Service category. Parameters that the CAR administrator sets provided basis for QoS categories; see the "Defining the Quality of Service (QoS) Values" section on page 4-5 and the "QoS by Gateway Report Configuration" section on page 6-6.

Good

QoS for these calls designates the highest possible quality.

Acceptable

QoS for these calls shows them slightly degraded but still falls within an acceptable range.

Fair

QoS for these calls, although degraded, still fall within a usable range.

Poor

QoS for these calls was unsatisfactory.

NA

These calls did not match any criteria for the established QoS categories.

Calls—Indicates the number of calls for each call classification.

Charge—Indicates the charge that is associated with each call. Call charge information that the CAR administrator provides for the CAR rating engine provides basis for charges. See the "Configuring the Rating Engine" section on page 4-1.


Figure 11-1 and Figure 11-2 display sample output from the Individual Bill and Department Bill Summary reports.

Figure 11-1 Individual Bill Summary Report Sample

Figure 11-2 Department Bill Summary Report Sample

Bill Detail Report Results

The report groups information by the user name in ascending order. The detail report includes the following fields (see Table 11-2).

Table 11-2 Detail Report Fields 

Field
Description

Date

The date that the call originated.

Orig. Time

The time that the call originated.

Orig.

The originating number from which the call was placed.

Dest.

The destination number to which the call was directed.

Call Classification—Call categories specify classes.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or that include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.

QOS—The number of calls for each Quality of Service category. Parameters that the CAR administrator sets provided basis for QoS categories; see the "Defining the Quality of Service (QoS) Values" section on page 4-5 and the "QoS by Gateway Report Configuration" section on page 6-6.

Good

QoS for these calls designates the highest possible quality.

Acceptable

QoS for calls that are slightly degraded but still within an acceptable range.

Fair

QoS for calls, that although degraded, still within a usable range.

Poor

QoS for calls that are unsatisfactory.

NA

Calls that did not match any criteria for the established QoS categories.

Duration(s)

The time, in seconds, that the call remained connected.

Charge

The charge that is associated with each call. Call charge information that the CAR administrator provided for the CAR rating engine provides the basis for charges. See the "Configuring the Rating Engine" section on page 4-1.


Figure 11-3 and Figure 11-4 displays sample output from the Individual Bill and Department Bill Detail reports.

Figure 11-3 Individual Bill Detail Sample Report

Figure 11-4 Department Bill Detail Sample Report

Top N By Charge or Duration Report Results

The fields for the Top N by Charge and the Top N by Duration vary depending on the report type. The reports show only outgoing calls. See Table 11-3.

Table 11-3 Top N by Charge and by Duration Report Fields 

Field
Description

By Individual Users

User

User names.

Calls

Total number of calls.

Duration(s)

The time, in seconds, that the call was connected.

Charge

The charge that is associated with each call. Call charge information that the CAR administrator provided for the CAR rating engine provides basis for charges. See the "Configuring the Rating Engine" section on page 4-1.

By Destinations

Dest

The destination of the calls.

Call Classification

The total number of calls for each call classification.

Calls

Total number of calls.

Duration

The time, in seconds, that the call was connected.

Charge

The charge that is associated with each call. Call charge information that the CAR administrator provided for the CAR rating engine provides basis for charges. See the "Configuring the Rating Engine" section on page 4-1.

By Number of Calls

User

User names.

Date

Date that the call occurred.

Orig Time

Time that the calls originated.

Orig

Origin of the calls.

Dest

Destination of the calls.

Call Classification

The total number of calls for each call classification.

Duration

The time, in seconds, that the call was connected.

Charge

The charge that is associated with each call. Call charge information that the CAR administrator provided for the CAR rating engine provides basis for charges. See the "Configuring the Rating Engine" section on page 4-1.


Figure 11-5 and Figure 11-6 display sample reports.

Figure 11-5 Top N Charge by Destinations Sample Report

Figure 11-6 Top N Duration by Destinations Sample Report

Top N By Number of Calls Report Results

The fields for the Top N by Number of Calls report vary depending on the report type. The report shows both incoming and outgoing calls. See Table 11-4.

Table 11-4 Top N by Number of Calls Report Fields 

Field
Description

By Individual Users

Users

User names.

Charge

The total amount of billing charges for all calls to that user. Call charge information that the CAR administrator provided for the CAR rating engine provides basis for charges. See the "Configuring the Rating Engine" section on page 4-1.

Duration(s)

The time, in seconds, that the call connected.

Calls Made

The total number of calls that the user placed.

Calls Received

The total number of calls that the user received.

Total Calls

The total number of incoming and outgoing calls.

By Extensions

Extension No

The extension that originated/placed and received the call.

Charge

The total amount of billing charges for all calls to that user. Call charge information that the CAR administrator provided for the CAR rating engine provides basis for charges. See the "Configuring the Rating Engine" section on page 4-1.

Duration

The time, in seconds, that the call was connected.

Calls Made

The total number of calls that the user placed.

Calls Received

The total number of calls that the user received.

Total Calls

The total number of incoming and outgoing calls.


Figure 11-7 displays sample report output of Top N by Number of Calls by Individual Users in PDF format.

Figure 11-7 Top N by Number of Calls Report Sample Output

Call Usage for Assistant—Detail Report Results

The report, which supports Cisco Unified Communications Manager Assistant, shows the number of calls that assistants handled for themselves, that the assistant handled for each manager, and the total number of calls that the assistant handled. The report groups information about calls that the assistant handled and calls that the assistant handled for the manager. The detail report includes the following fields (see Table 11-5).

Table 11-5 Detail Report Fields 

Field
Description

Date

The date that the call originated.

Orig. Time

The time that the call originated.

Orig.

The originating number from which the call was placed.

Dest.

The destination number to which the call was directed.

Call Classification

The type of call (internal, incoming, and so on.)

Duration (sec)

The time, in seconds, that the call connected.


Figure 11-8 displays sample output from a Call Usage for Assistant Detail report in PDF format.

Figure 11-8 Call Usage for Assistant Detail Report

Call Usage for Assistant—Summary Report Results

The report, which supports Cisco Unified Communications Manager Assistant, shows information about calls that the assistant handled for themselves and that the assistant handled for the manager. The reports groups call information by attendant name. The summary report includes the following fields (see Table 11-6).

Table 11-6 Summary Report Fields 

Field
Description

Assistant-Extn/Manager

Shows the assistant name and directory number. If the assistant handles a call for a manager, the manager name displays.

Call Classification—Call categories specify classes.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or that include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

Incoming

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter through a gateway, and go into the Cisco Unified Communications Manager network.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.

Calls

The number of calls that the assistant handled or the assistant handled for the manager.

Duration (sec)

The total duration for all the calls for the particular call classification.


Figure 11-9 displays sample output of the Call Usage for Assistant Summary report in PDF format.

Figure 11-9 Call Usage for Assistant Summary Report

Call Usage for Manager—Detail Report Results

The report, which supports Cisco Unified Communications Manager Assistant, provides information about calls that managers handle for themselves and that assistants handle for managers. The report groups information by the assistant name and shows the total number of calls that the manager handles and that the assistant handles for the manager. The detail report includes the following fields (see Table 11-7).

Table 11-7 Detail Report Fields 

Field
Description

Date

The date that the call originates.

Orig. Time

The time that the call originates.

Orig.

The originating number from which the call is placed.

Dest.

The destination number to which the call is directed.

Call Classification

The type of call (internal, incoming, and so on.)

Duration (sec)

The time, in seconds, that the call connects.


Figure 11-10 displays sample output from the Call Usage for Manager Detail report.

Figure 11-10 Call Usage for Manager Detail Report

Call Usage for Manager—Summary Report Results

The report, which supports Cisco Unified Communications Manager Assistant, shows information about calls that the managers handle for themselves and that the assistants handle for the managers. The report groups information by the manager name and shows the total number of calls that are handled for each manager. The report includes the following fields (see Table 11-8).

Table 11-8 Summary Report Fields 

Field
Description

Manager-Extn/Assistant

Shows the manager name and directory number. If the assistant handles a call for a manager, the assistant name displays.

Call Classification—Call categories specify classes.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or which include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

Incoming

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter through a gateway, and go into the Cisco Unified Communications Manager network.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.

Calls

The number of calls that the assistant or the manager handles.

Duration

The total duration for all the calls for the particular call classification.


Figure 11-11 displays sample output of the Call Usage for Manager Summary report in PDF format.

Figure 11-11 Call Usage for Manager Summary Report

Cisco IP Phone Services Report Results

The Cisco IP Phone Services report includes the following fields. See Table 11-9.

Table 11-9 Cisco Unified IP Phone Services Report Fields 

Field
Description

Cisco IP Phone Services

The name of the selected service.

Number of Subscribers

The total number of subscribers for a given service.

% Subscription

The percentage of users who are subscribed to a given service, out of the total number of subscriptions for all services.


Figure 11-12 displays sample output from the Cisco IP Phone Services Report in PDF format.

Figure 11-12 Cisco IP Phone Services Report Sample Output

QoS Detail Report Results

The QoS Detail report includes the following fields. See Table 11-10.

Table 11-10 QoS Detail Report Fields 

Field
Description

Orig. Time

The time that the call was placed, in 24-hour, minute, and second format.

Term. Time

The time that the call disconnected, in 24-hour, minute, and second format.

Duration(s)

The amount of time, in seconds, that the call was connected.

Orig.

The originating number from which the call was placed.

Dest.

The destination number to which the call was directed.

Call Classification—Call categories specify classes.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or that include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Incoming

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter through a gateway, and go into the Cisco Unified Communications Manager network.

Tandem

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter the Cisco Unified Communications Manager network through a gateway, and are transferred outbound from the Cisco Unified Communications Manager network through a gateway.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.

Orig. Codec

The codec that the originating device uses.

Dest. Codec

The codec that the destination device uses.

Orig. Device

The name of the device that placed the call.

Dest. Device

The name of the device that received the call.

Orig. QoS

The voice quality that the device that placed the call experienced.

Dest. QoS

The voice quality that the device that received the call experienced.


Figure 11-13 displays sample output of the QoS Detail report in PDF format.

Figure 11-13 QoS Detail Report

QoS Summary Report Results

The QoS Summary report includes the following fields. See Table 11-11. If you select PDF format for the report output, the report shows a pie chart that displays the QoS of the total number of calls.

Table 11-11 QoS Summary Report Fields 

Field
Description

Quality of Service

The quality of service of the calls.

Call Legs

Number of call legs with the quality of service that the Quality of Service field specified.


Figure 11-14 displays sample output of the QoS Summary Report in PDF format.

Figure 11-14 QoS Summary Report in PDF Format

QoS by Gateways Report Results

The QoS by Gateways report provides the following information. See Table 11-12.

Table 11-12 QoS by Gateways Report Fields 

Field
Description

Time/Day

Indicates the cumulative hours of the day(s), the days of the week, or the days of the month for the selected date range.

% of Call Legs

Displays the percentage of calls for each gateway for the hours of the day, the days of the week, or the days of the month for the selected date range.


Figure 11-15 displays sample output of the QoS by Gateways report in PDF format.

Figure 11-15 QoS by Gateways Report

QoS by Call Types Report Results

The QoS by Call Types report provides the following information. See Table 11-13.

Table 11-13 QoS by Call Types Report Fields 

Field
Description

Time/Day

The cumulative hours of the day(s), the days of the week, or the days of the month for the selected date range.

% of Call Legs

The percentage of calls for each gateway for the hours of the day, the days of the week, or the days of the month for the selected date range.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or that include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Incoming

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter through a gateway, and go into the Cisco Unified Communications Manager network.

Tandem

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter the Cisco Unified Communications Manager network through a gateway, and are transferred outbound from the Cisco Unified Communications Manager network through a gateway.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.


Figure 11-16 displays sample output of the QoS by Call Types report in PDF format.

Figure 11-16 QoS by Call Types Report

Traffic Summary Report Results

The Traffic Summary and Traffic Summary by Extension reports contain the same information and include some or all the following fields. See Table 11-14. A separate line displays under the report title for the Busy Hour Call Completion (BHCC) number for that day.

\

Table 11-14 Traffic Summary Report Fields 

Field
Description

Time/Day

The cumulative hours of the day(s), the days of the week, or the days of the month for the selected date range.

Average Number of Calls

The percentage of calls for each gateway for the hours of the day, the days of the week, or the days of the month for the selected date range.

Internal

Intracluster calls that originate in the Cisco Unified Communications Manager network and end in the same Cisco Unified Communications Manager network (no gateways or trunks are used).

Local

Local calls that are routed through the public switched telephone network (PSTN) to numbers without an area code or that include one of the local area codes.

Long Distance

Long-distance calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

International

International calls that originate in the Cisco Unified Communications Manager network that go out through the PSTN.

On Net

Outgoing calls that originate on one Cisco Unified Communications Manager network, go out through a trunk, and terminate on a different Cisco Unified Communications Manager network. For CAR purposes, any outgoing call can be classified as an On Net call if it is configured as such in the CAR dial plan configuration window. See "Configuring the Dial Plan" section on page 3-2.

Incoming

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter through a gateway, and go into the Cisco Unified Communications Manager network.

Tandem

Inbound calls that originate outside the Cisco Unified Communications Manager network, enter the Cisco Unified Communications Manager network through a gateway, and are transferred outbound from the Cisco Unified Communications Manager network through a gateway.

Others

All other outgoing calls, such as toll-free numbers or emergency calls such as 911.

Total

The total number of calls for each hour or day.


Figure 11-17 displays sample output of the Traffic Summary Report results in PDF format.

Figure 11-17 Traffic Summary Report Results

Authorization Code Name Call Details Report Results

This report shows the usage of specific authorization code names. For security purposes, the authorization code name (description) displays and not the authorization code. The detail report includes the following fields (see Table 11-15).

Table 11-15 Authorization Code Name Call Details Report Fields 

Field
Description

Orig.

The originating number from which the call was placed.

Dest.

The destination number to which the call was directed.

Orig. Date Time

The date and time that the call originated.

Duration (sec)

The time, in seconds, that the call connected.

Call Classification

The type of call (internal, incoming, on so on.)

Authorization Level

The authorization level for calls for each chosen authorization code name.


Figure 11-18 displays sample output of the Authorization Code Name Call Details report in PDF format.

Figure 11-18 Authorization Code Name Call Details Report

Authorization Level Call Details Report Results

This report shows the usage of specific authorization levels. The detail report includes the following fields (see Table 11-16).

Table 11-16 Authorization Level Call Details Report Fields 

Field
Description

Orig.

The originating number from which the call was placed.

Dest.

The destination number to which the call was directed.

Orig. Date Time

The date and time that the call originated.

Duration (sec)

The time, in seconds, that the call connected.

Call Classification

The type of call (internal, incoming, and so on.)

Authorization Code Name

The authorization code name for each authorization level that you chose.


Figure 11-19 displays sample output of the Authorization Level Call Details report in PDF format.

Figure 11-19 Authorization Level Call Details Report

Client Matter Code Details Report Results

The report shows the usage of specific client matter codes. The detail report includes the following fields (see Table 11-17).

Table 11-17 Detail Report Fields 

Field
Description

Orig.

The originating number from which the call was placed.

Dest.

The destination number to which the call was directed.

Orig. Date Time

The date and time that the call originated.

Duration (sec)

The time, in seconds, that the call connected.

Call Classification

The type of call (internal, incoming, and so on.)


Figure 11-20 displays sample output of the Client Matter Code Details report in PDF format.

Figure 11-20 Client Matter Code Details Report

Malicious Call Details Report Results

The Malicious Call Details report provides information about malicious calls. The report provides the following fields. See Table 11-18.

Table 11-18 Malicious Call Details Report Fields 

Field
Description

Orig. Time

Time at which the malicious call originated.

Term. Time

Time at which the malicious call terminated.

Duration

Total time of malicious call in seconds.

Orig.

Originating DN.

Dest.

Destination DN.

Orig. Device

Name of the originating device.

Dest. Device

Name of the destination device.

Call Classification

Classification of the malicious call.


Figure 11-21 displays sample output of the Malicious Calls Detail report in PDF format.

Figure 11-21 Malicious Calls Detail Report

Precedence Call Summary Report Results

The Precedence Call Summary report provides information about calls based on precedence levels. The report displays the call summary for the precedence values in the form of a bar chart on an "Hour of Day," "Day of Week," or "Day of Month" basis for each precedence level that you choose. If you choose to display the report in PDF format, two tables, one reflecting the bar chart, and the other listing the "Number of Calls" and "Percentage" for each precedence level that was chosen, display in the report. See Table 11-19.

Table 11-19 Precedence Call Summary Report Fields 

Field
Description

Time/Day

Indicates the cumulative hours of the day(s), the days of the week, or the days of the month for the selected date range.

Call Legs

Number of calls for each precedence level by time/day.

Precedence Level

Precedence level value of the call.

No. of Call Legs

Number of call legs per each precedence level.

Percentage

Percentage of calls per each precedence level.


Figure 11-22 displays sample output of the Precedence Call Summary by Hour of Day report in PDF format.

Figure 11-22 Precedence Call Summary Report

System Overview Report Results

The system overview provides information about all parts of the Cisco Unified Communications Manager network. The report provides the following sections. See Table 11-20.

Table 11-20 System Overview Report 

Field
Description

Top 5 Users based on Charge

Details the five users who have incurred the highest charges for calls that occurred during the specified date range. See the "Top N By Charge or Duration Report Results" section for details about this section of the system overview report.

Top 5 Destinations based on Charge

Details the five called numbers that have incurred the highest charges for calls during the specified date range. See the "Top N By Charge or Duration Report Results" section for details about this section of the system overview report.

Top 5 Calls based on Charge

Details the five calls that have incurred the highest charges for calls during the specified date range. See the "Top N By Charge or Duration Report Results" section for details about this section of the system overview report.

Top 5 Users based on Duration

Details the five users who have spent the most time on calls during the specified date range. See Top N By Charge or Duration Report Results for details about this section of the system overview report.

Top 5 Destinations based on Duration

Details the five called numbers that have been engaged in calls for the longest time during the specified date range. See the "Top N By Charge or Duration Report Results" section for details about this section of the system overview report.

Top 5 Calls based on Duration

Details the five longest calls for the specified date range. See the "Top N By Charge or Duration Report Results" section for details about this section of the system overview report.

Traffic Summary Report - Hour of Day

Shows the volume of calls during the specified date range based on each hour of the day. If the date range is within one day, the system identifies the hour with the highest traffic volume (the BHCC number). See the "Traffic Summary Report Results" section for details about this section of the system overview report.

Traffic Summary Report - Day of Week

Shows the volume of calls during the specified date range based on each day of the week. See the "Traffic Summary Report Results" section for details about this section of the system overview report.

Traffic Summary Report - Day of Month

Shows the volume of calls during the specified date range based on each day of the month. See the "Traffic Summary Report Results" section for details about this section of the system overview report.

Quality of Service Report - Summary

Shows the number of calls that fell within each voice-quality category during the specified date range. See the "QoS Summary Report Results" section for details about this section of the system overview report.

Gateway Summary Report

Shows the summary of the call classification for each gateway along with the QoS, the number of calls, and the duration for each classification for the gateway during the specified date range. See the "QoS by Gateways Report Results" section for details about this section of the system overview report.


CDR Error Report Results

The CDR Error report provides the following information. See Table 11-21.

Table 11-21 CDR Error Report Fields 

Field
Description

Time

The hour for the specified day that the error occurred.

No of Error CDRs

The total number of CDR data records that were not processed during loading into CAR due to an error.

No of Valid CDRs

The total number of CDR data records that were successfully load into CAR.

% of Error CDRs

The percentage of failed CDR data records out of all the CDR data records to be loaded.


Figure 11-23 displays sample output of the CDR Error report in PDF format.

Figure 11-23 CDR Error Report

Gateway Detail Report Results

The Gateway Detail report includes the following fields. See Table 11-22.

Table 11-22 Gateway Detail Report Fields 

Field
Description

Date

The date when the call went through the gateway.

Orig. Time

The time when the call went through the gateway.

Term. Time

The time that the call terminated.

Duration(s)

The duration, in seconds, that the call was connected. The duration specifies the difference between the Dest Connect and the Dest Disconnect times.

Orig

The directory number from which the call was placed.

Dest

The directory number to which the call was originally placed. If the call was not forwarded, this directory number should match the Final Destination number. If the call was forwarded, this field contains the original destination number of the call before it was forwarded.

Orig. Codec

The codec code (compression or payload code) that the call originator used on its sending side during this call. This code may differ from the codec code that was used on its receiving side.

Dest. Codec

The codec code (compression or payload code) that the destination used on its sending side during this call. This code may differ from the codec code that was used on its receiving side.

Orig. Device

The device name of the device that placed the call. For incoming and tandem calls, this field specifies the device name of the gateway.

Dest Device

The device name of the device that received the call. For outgoing and tandem calls, this field specifies the device name of a gateway. For conference calls, this field specifies the device name of the conference bridge.

Orig QoS

QoS shows the voice-quality grade that was achieved for the calls.

Dest QoS

The QoS category that was experienced by the receiver of the call.


Figure 11-24 displays sample output of the Gateway Detail Report in PDF format.

Figure 11-24 Gateway Detail Report

Gateway Summary Report Results

The Gateway Summary report includes the following fields. See Table 11-23.


Note The Gateway Summary report segregates calls for each call classification that the user selects and divides the calls based on QoS type.


Table 11-23 Gateway Summary Report Fields 

Field
Description

Call Classification

Shows the type of call (internal, incoming, and tandem.)

Quality of Service

Shows a summary of the performance of the various gateways with the total number of calls for each voice-quality category. The parameters set in the "Defining the Quality of Service (QoS) Values" section on page 4-5 provide the basis for all voice-quality categories.

Good—QoS for these calls specifies the highest possible quality.

Acceptable—QoS for these calls, although slightly degraded, still falls within an acceptable range.

Fair—QoS for these calls, although degraded, still falls within a usable range.

Poor—QoS for these calls was unsatisfactory.

NA—These calls did not match any criteria for the established QoS categories.

Calls

Shows the total calls for the particular call classification.

Duration (sec)

Shows the total duration for all the calls for the particular call classification.


Figure 11-25 displays sample output of the Gateway Summary Report in PDF format.

Figure 11-25 Gateway Summary Report

Gateway and Route Utilization Report Results

The Gateway, Route Group, Route List, and Route Pattern Utilization reports provide similar output. If you choose to display the report in PDF format, the report shows the utilization as a bar chart. A graph displays for each selected gateway or route group. See Table 11-24.

Table 11-24 Gateway and Route Utilization Report Fields 

Field
Description

Time/Day

Time in one-hour blocks if you chose Hourly or one-day blocks if you chose weekly or monthly. The results show the utilization for each hour or day for the entire period that is shown in the from and to dates.

%

Gateway, route group, route list, or route pattern utilization percentage. This field gives the estimated utilization percentage of the gateways or route groups or route lists or route patterns relative to the total number of calls that all the gateways put together can support at any one time.


Figure 11-26 displays sample output of the Gateway Utilization Report in PDF format.

Figure 11-26 Gateway Utilization Report

Figure 11-27 displays sample output of the Route/Hunt List Utilization report in PDF format.

Figure 11-27 Route/Hunt List Utilization Report

Figure 11-28 displays sample output from the Route and Line Group Utilization report in PDF format.

Figure 11-28 Route and Line Group Utilization Report

Figure 11-29 displays sample output of the Route Pattern/Hunt Path Utilization report in PDF format.

Figure 11-29 Route Pattern/Hunt Path Utilization Report

Conference Call Detail Report Results

You can choose to generate Conference Call information in either a summary or a detailed report. The reports display the call details in a table when you generate the report in PDF format. The following tables show the fields in the Conference Call Detail and Summary reports. See Table 11-26 and Table 11-25.


Note The report criteria include the type of conference (ad hoc and/or meet-me) and the From and To date range.


Table 11-25 Conference Call Detail Report Fields 

Field
Description

Conference Start Time

Time at which conference started.

Conference End Time

Time at which conference ended.

Connect Time

Time at which conference participants connected to conference.

Disconnect Time

Time at which conference participants disconnected from conference.

Duration

Total time of conference.

Directory Number

Directory number of participants.

Call Classification

Call types of conference (internal, incoming, and so on.)

Device Name

Names of the conference devices that were used.

QoS

Quality of service.


Table 11-26 Conference Call Detail Summary Report Fields 

Field
Description

Orig. Time

Time that the first participant enters the conference.

Term. Time

Time that the last participant leaves the conference.

No. of Participants

Number of participants in the conference.

Duration

Sum of the duration of individual participants in the conference in seconds.

Device Name

Names of the conference devices that were used.


Figure 11-30 displays sample output of the Conference Call Details Summary report in PDF format.

Figure 11-30 Conference Call Details Summary Report

Conference Bridge Utilization Report Results

The Conference Bridge Utilization report provides the following fields. If you choose PDF format, the report shows the utilization as a table. See Table 11-27.

Table 11-27 Conference Bridge Utilization Report Fields 

Field
Description

Time/Day

Time in one-hour blocks if you chose Hourly or one-day blocks if you chose day of week or daily.

% Usage

Conference bridge utilization percentage.

Conf. Bridge

The conference bridge device that is used to hold conference calls.

Type

Either hardware or software conference bridge.

Max Streams

The number of conferences that can be held at a time along with the number of people per conference.


Figure 11-31 displays sample output of the Conference Bridge Utilization report in PDF format.

Figure 11-31 Conference Bridge Utilization Report

Voice Messaging Utilization Report Results

The Voice Messaging Utilization report provides the following fields. See Table 11-28.

Table 11-28 Voice Messaging Utilization Report Fields 

Field
Description

Time/Day

Time in one-hour blocks if you chose Hourly or one-day blocks if you chose day of week or daily.

% Usage

Voice-messaging percentage.

Voice Messaging Ports

The sum of the maximum number of ports for all the gateways under the route patterns that are configured for the voice messaging systems and the entries in the Device table of Cisco Unified Communications Manager that have type Class as 8.

Voice Messaging Gateways

The originating or destination device name as the gateways under the route patterns that are configured for the voice-messaging systems.

Number of Ports

The number of ports that the voice messaging gateway supports.


Figure 11-32 displays sample output of the Voice Messaging Utilization report in PDF format.

Figure 11-32 Voice Messaging Utilization Report

Understanding the CDR Search Results

The following sections describe CDR search results:

Understanding the Results for CDR Search

Media Information

CDR and CMR Dump Tables

Understanding the Results for CDR Search

The CDR search allows users to view the CDR/CMR fields as described in "CDR and CMR Dump Tables" section. The CDR search retrieves the CDR/CMR files from the tbl_billing_data and tbl_billing_error tables of the CAR database.

See Table 11-29.

Table 11-29 CDR Search Results 

Field
Description

Sl No

This field specifies the serial or record number.

Call Type

This field specifies the type of call: simple, transfer, forward, pickup, conference, refer, replaces, or redirection.

GCID_CMId
GCID_CallId

This field specifies the call identifiers that are associated with all the records for the entire call.

Orig Node Id
Dest Node Id

This field specifies the node within the Cisco Unified Communications Manager cluster where the call originator/destination was registered at the time of the call.

Orig Leg Id
Dest Leg Id

This field specifies the unique identifiers (within a cluster) to the originating/destination leg of a call.

Calling No
Calling No Partition

The calling number specifies the directory number where the call originated. The calling partition specifies the partition that is associated with the calling party.

Called No
Called No Partition

The called number specifies the directory number from which the call was initially placed and is the same as the Dest No when the call is not transferred or forwarded. The called partition specifies the partition that is associated with the called party.

Dest No
Dest No Partition

The destination number specifies the directory number where the call finally terminated and is the same as the called number when the call is not transferred or forwarded. The destination number partition specifies the partition that is associated with the destination number.

Last Rd No
Last Rd No Partition

The last redirected number specifies the directory number from which the call was finally redirected. The last redirected number partition specifies the partition that is associated with the last redirected number.

Media Info
Orig Pkts Rcd Dest Pkts Rcd
Orig Pkts Lost Dest Pkts Lost

This field specifies the packets that were received or lost for the origination or destination leg of a call and a link to the media information. See the "CDR and CMR Dump Tables" section for information about the CDR and CMR Dump tables.

CDR - CMR Dump

This field specifies a link to the CDR and CDR dump tables. This link allows the users to view the values in the CDR/CMR fields. See the "CDR and CMR Dump Tables" section for information about the CDR and CMR Dump tables.


Media Information

The media information table provides the following information. See Table 11-30.

Table 11-30 CDR Media Information 

Field
Description

Origination Leg

A unique identifier (within a cluster) for the originating leg of a call.

Destination Leg

A unique identifier (within a cluster) for the destination leg of a call.

Parameter

The media parameters MediaTransportAdd_Ip, PayLoadCapability, MediaCap_g723BitRate, Packets Sent, Octets Sent, Packets Received, Octets Received, Packets Lost, Jitter, Latency, QoS, VideoCap_Codec, VideoCap_Bandwidth, VideoCap_Resolution, VideoTransportAddress_IP, and VideoTransportAddress_Port

Origination

The value for all the preceding parameters for the origination leg of the call.

Destination

The value for all the preceding parameters for the destination leg of the call.


CDR and CMR Dump Tables

The CDR and CMR dump tables provide the following information. See Table 11-31.


Note You can view the content of the voice quality metrics field, varVQMetrics, in the Origination CMR and Destination CMR fields.


Table 11-31 CDR and CMR Dump Tables 

Field
Description

CDR

This field specifies the call detail record fields.

Origination CMR

Only a single set of fields for origination and destination exists. You can find the origination or destination CMR by using the leg IDs. If the leg IDs of the CMR match the Orig/Dest leg ID of the CDR, the following record represents Orig/Dest CMR.

Destination CMR

Only a single set of fields for origination and destination exists. You can find the origination or destination CMR by using the leg IDs. If the leg IDs of the CMR match the Orig/Dest leg ID of the CDR, the following record represents Orig/Dest CMR.


The following example displays output from a CDR dump file:

CDR Dump File Output Example

cdrRecordType,globalCallID_callManagerId,globalCallID_callId,orignodeId,destnodeId,origleg
callIdentifier,destlegidentifier,orignumberPacketsSent,orignumberOctetsSent,orignumberPack
etsReceived,orignumberOctetsReceived,orignumberPacketsLost,destnumberPacketsSent,destnumbe
rOctetsSent,destnumberPacketsReceived,destnumberOctetsReceived,destnumberPacketsLost,origj
itter,destjitter,origlatency,destlatency,pkid,origdeviceName,destdeviceName,origvarVQMetri
cs,destvarVQMetrics,globalCallId_ClusterID,callingPartyNumber,finalCalledPartyNumber,calli
ngPartyNumberPartition,finalCalledPartyNumberPartition
1,1,233,1,1,31565399,31565400,2159941,371509852,2158009,371177548,0,0,0,0,0,0,0,0,0,0,1020
e21e-111d-4171-b778-fd7e54c2283d,SEP001955098750,9.9.1.95,MLQK=4.5000;MLQKav=4.4270;MLQKmn
=3.6833;MLQKmx=4.5000;MLQKvr=0.95;CCR=0.0018;ICR=0.0000;ICRmx=0.0668;CS=3000;SCS=441,,Stan
dAloneCluster,1006,1002,,
1,1,234,1,1,31565401,31565402,2159930,371507960,2158063,371186836,2,0,0,0,0,0,0,0,0,0,16ba
f132-4c6a-4ad9-bf4b-ac560d2a4cf1,SEP00192F74C18F,9.9.1.95,MLQK=4.4438;MLQKav=4.4274;MLQKmn
=3.7094;MLQKmx=4.5000;MLQKvr=0.95;CCR=0.0018;ICR=0.0000;ICRmx=0.0697;CS=2943;SCS=436,,Stan
dAloneCluster,1005,1003,,