Cisco Unified CallManager CDR Analysis and Reporting Administration Guide, Release 5.0(1)
CAR Report Results
Downloads: This chapterpdf (PDF - 353.0KB) | 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 Cisco IPMA Assistant—Detail

Call Usage for Cisco IPMA Assistant—Summary

Call Usage for Cisco IPMA Manager—Detail

Call Usage for Cisco IPMA Manager—Summary

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

Authorization Level Call Details

Client Matter Code Details

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


This chapter describes report output information for each of the CAR report types:

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 Cisco IPMA Assistant—Detail

Call Usage for Cisco IPMA Assistant—Summary

Call Usage for Cisco IPMA Manager—Detail

Call Usage for Cisco IPMA Manager—Summary

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

Authorization Level Call Details

Client Matter Code Details

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

Media Information

CDR and CMR Dump Tables

Bill Summary Report Results

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

Table 10-1 Summary Report Fields 

Field
Description

Call Classification—Call categories specify classes.

Internal

Intracluster calls that originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

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 and the "Configuring QoS Parameters" section on page 6-5.

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.


Bill Detail Report Results

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

Table 10-2 Detail Report Fields 

Field
Description

Date and Orig. Time

The date and 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.

Internal

Intracluster calls that originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

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 and the "Configuring QoS Parameters" section on page 6-5.

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 unsatisfactory.

NA

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

Duration(s)

The time, in seconds, that the call 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.


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 10-3.

Table 10-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.

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.

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.


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 10-4.

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

Field
Description

By Individual Users

Users

User names.

Duration(s)

The time, in seconds, that the call connected.

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.

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.

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.


Call Usage for Cisco IPMA Assistant—Detail

The report 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 10-5).

Table 10-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.


Call Usage for Cisco IPMA Assistant—Summary

The report 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 10-6).

Table 10-6 Detail 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 originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

Incoming

Inbound calls that originated outside the Cisco CallManager network, entered through a gateway, and went into the Cisco CallManager network.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

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.


Call Usage for Cisco IPMA Manager—Detail

The report 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 10-7).

Table 10-7 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.


Call Usage for Cisco IPMA Manager—Summary

The report 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 10-8).

Table 10-8 Detail 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 originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

Incoming

Inbound calls that originated outside the Cisco CallManager network, entered through a gateway, and went into the Cisco CallManager network.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

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.


Cisco IP Phone Services Report Results.

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

Table 10-9 Cisco 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 have subscribed to a given service, out of the total number of subscriptions for all services.


QoS Detail Report Results

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

Table 10-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 originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

Incoming

Inbound calls that originated outside the Cisco CallManager network, entered through a gateway, and went into the Cisco CallManager network.

Tandem

Inbound calls that originated outside the Cisco CallManager network, entered the Cisco CallManager network through a gateway, and were transferred outbound from the Cisco CallManager 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 the device that received the call experienced.


QoS Summary Report Results

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

Table 10-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.


QoS by Gateways Report Results

The QoS by gateways report provides the following information. See Table 10-12.

Table 10-12 QoS Gateway 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.


QoS by Call Types Report Results

The QoS by call types report provides the following information. See Table 10-13.

Table 10-13 QoS Call Type 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 originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

Incoming

Inbound calls that originated outside the Cisco CallManager network, entered through a gateway, and went into the Cisco CallManager network.

Tandem

Inbound calls that originated outside the Cisco CallManager network, entered the Cisco CallManager network through a gateway, and were transferred outbound from the Cisco CallManager network through a gateway.

Others

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


Traffic Summary Report Results

The traffic summary and traffic summary by extension reports contain the same information and include some or all of the following fields. See Table 10-14.

Table 10-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 originated in the Cisco CallManager network and ended in the same Cisco CallManager network (no gateways 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 CallManager network that go out through the PSTN.

International

International calls that originate in the Cisco CallManager network that go out through the PSTN.

On Net

Outgoing, intercluster calls that originate on one Cisco CallManager cluster and terminate on a different cluster.

Incoming

Inbound calls that originated outside the Cisco CallManager network, entered through a gateway, and went into the Cisco CallManager network.

Tandem

Inbound calls that originated outside the Cisco CallManager network, entered the Cisco CallManager network through a gateway, and were transferred outbound from the Cisco CallManager 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.


Authorization Code Name Call Details

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

Table 10-15 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, on so on.)

Authorization Level

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


Authorization Level Call Details

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

Table 10-16 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.)

Authorization Code Name

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


Client Matter Code Details

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

Table 10-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.)


Malicious Call Details Report Results

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

Table 10-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.


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. Two tables, one reflecting the bar chart, and the other listing the "Number of Calls" and "Percentage" for each precedence level that was chosen, displays in the report.

Table 10-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.


System Overview Report Results

The system overview provides information about all parts of the Cisco CallManager network. The report provides the following sections. See Table 10-20.

Table 10-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. 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 10-21.

Table 10-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 loaded to CAR.

% of Error CDRs

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

Error Description

An error that occurred when the system was trying to load the CDR data records.

% of Error CDRs

The percentage of CDR data records that failed due to the corresponding error description.


Gateway Detail Report Results

The gateway detail report includes the following fields. See Table 10-22.

Table 10-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 type (compression or payload type) that the call originator used on its sending side during this call. This type may differ from the codec type that was used on its receiving side.

Dest. Codec

The codec type (compression or payload type) that the destination used on its sending side during this call. This type may differ from the codec type 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

Quality of service 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.


Gateway Summary Report Results

The gateway summary report includes the following fields. See Table 10-23.


Note The gateway summary report segregates calls for each call classification the user selects and divides the calls on QoS type.


Table 10-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 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(s)

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


Gateway and Route Utilization Report Results

The gateway, route group, route list, and route pattern utilization reports provide similar output. If you generate these reports in CSV format, the report displays in a table. If you chose PDF, the report shows the utilization as a bar chart. A graph displays for each selected gateway or route group. See Table 10-24.

Table 10-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.

% of Calls

Gateway, route group, route list, or route pattern utilization percentage. This field gives the cumulative 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.


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 whether you chose to generate the report in the CSV or PDF format. The following tables show the fields in the Conference Call Detail and Summary reports.


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


Table 10-25 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.


Table 10-26 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.


Conference Bridge Utilization Report Results

The report provides the following fields. If you chose CSV output, the report displays the utilization in a table. If you chose PDF, the report shows the utilization as a bar chart. See Table 10-27.

Table 10-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.


Voice Messaging Utilization Report Results

The report provides the following fields. If you chose CSV output, the report displays the utilization in a table. If you chose PDF, the report shows the utilization as a bar chart. See Table 10-28.

Table 10-28 Voice-Messaging Utilization Report Fields 

Field
Description

% Usage

Voice-messaging percentage.

Time/Day

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

Voice Messaging Ports

The sum of the maximum number of ports for all the gateways under the route patterns that are configured for Octel voice messaging and the entries in the Device table of Cisco CallManager 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 Octel system.

Number of Ports

The number of ports that the voice-messaging gateway supports.


Understanding the CDR Search Results

The following sections describe CDR search results: the "Understanding the Results for CDR Search" section, the "Media Information" section, and the "CDR and CMR Dump Tables" section.

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 10-29.

Table 10-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 CallManager 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 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 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 following information. See Table 10-30.

Table 10-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, VideoCap_Codec, VideoCap_Bandwidth, VideoCap_Resolution, VideoTransportAddress_IP, VideoTransportAddress_Port, and QoS.

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 10-31.


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


Table 10-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.