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,,