Table of Contents

Reporting Framework Overview
Generating an SLC Summary Report
Generating an SLC Detailed Report
Generating an SLA Summary Report
Generating an SLA Detailed Report

Understanding SLA Detailed Report Exceptions
Understanding ICMP Echo Detailed Report Exceptions
Understanding UDP Echo Detailed Report Exceptions
Understanding DNS Detailed Report Exceptions
Understanding HTTP Detailed Report Exceptions
Understanding VoIP Detailed Report Exceptions

Generating Reports

This chapter contains the following sections:

• Reporting Framework Overview

• Generating an SLC Summary Report

• Generating an SLC Detailed Report

• Generating an SLA Summary Report

• Generating an SLA Detailed Report

Reporting Framework Overview

SLM is designed with a reporting framework that aggregates and analyzes data in search of threshold violations. This process is repeated in defined time increments. The resulting data is displayed in HTML format.

The ME 1100 Series collects this data from a monitored device pair, then stores the data in a database. The SLM server periodically retrieves that data from the ME 1100 Series, where it is aggregated and rolled into daily, monthly, and yearly reports.

Note It can take up to 2 hours for data to be displayed in reports.

Reports are designed in an overall summary format to easily locate SLCs and SLAs with exceptions, and a more detailed format that allows you to drill down to examine specific error information.

The SLM database stores SLC and SLA metadata, polling data, and report summary data, which are stored in the following time increments:

• Up to 48 hours of aggregated data at 5-minute intervals (576 maximum readings)

• Up to 31 days of hourly average metrics readings (744 maximum readings)

• Up to 12 months of daily average metrics readings (365 maximum readings)

• Up to 2 years of monthly average data (24 maximum readings)

Note Time increments are based on a single operation being monitored.

To begin generating reports, you select Service Level Management>
Service Level Reports>View Reports from the CiscoWorks2000 desktop. A new browser window opens from which you make your report selections.

Generating an SLC Summary Report

The SLC Summary Report is a high-level exceptions report for all SLCs within a folder. The report contains each SLC name, exceptions, device pairs with valid data, enabled status, and time monitored.

By default, the first folder listed in the SLM navigation tree is selected, and the date for daily reports is the current day.

Note When requesting reports for the first time, there is a delay resulting from the Java Server Pages (JSPs) compiling.

Tips You can view reports from the Cisco Service Level Manager window by selecting a folder from the SLM navigation tree. Using the View drop-down menu, select View>Report.

Procedure

Table 4-1 defines SLC Summary Report Page elements.

Table 4-1: SLC Summary Report Page Elements and Descriptions

Element	Description
Top frame	Displays Java reports browser for selecting a folder, SLC, or SLA report.
Bottom frame	Displays an HTML report varying according to what was selected in the top frame.
Heading	Indicates you are in report browser and viewing SLA Summary Report. This is the type of report shown when you select an SLA from the selector. The heading is updated depending on the report selection.
Refresh	Reloads navigation tree from server and returns window to default settings.
Edit SLC	Takes you to Define SLC window. If you do not have appropriate privileges, this element is grayed out.
Help	Opens online help for this window.
Browse selector	Displays hierarchical representation of folders, SLCs, SLAs, and device pairs. What you select determines what report is retrieved and displayed in bottom frame. Device pairs shown in this selector display host name and domain name.
Select Report Date selector	Enables you to choose daily, weekly, or monthly reports. There are 31 daily reports, 12 monthly reports, and 2 yearly reports. Lists are sorted in reverse chronological order.
Go button	Uses context selected in top frame, retrieves desired report, and displays resulting HTML page in bottom frame. Grayed out until you change time or report context (for example, nongray indicates to click for bottom frame contents to match currently selected time and report context).

The SLC Summary Report for the report type selected displays averaged exception information for each SLC in that folder. The report information appears in the bottom frame, as shown in Figure 4-2, and includes:

• Exceptions---Shown as a percentage. The number of device pairs with valid data that violates SLA thresholds. For example, (0/2) means there are zero exceptions found in the 2 device pairs that have valid data.
  
• Device Pairs With Valid Data---Shown as a percentage. Includes total number of device pairs and device pairs with valid data. For example (0/9) means there are 9 device pairs, of which 0 has valid data.
  
• Enabled---Status is shown as Yes or No. Yes = enabled; No = disabled.
  

Table 4-2 defines SLC Summary Report elements.

Table 4-2: SLC Summary Report Elements and Descriptions

Element	Description
Report frame heading	Indicates context of current screen frame. Upper context is committed when you click Go. Only bottom frame is printed if you click Print.
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
SLC Name	Displays user-defined SLC name.
Exceptions1	Displays exceptions (as a percentage) that occurred in selected time frame (the number of device pairs in SLC with any exception noted). Icons graphically distinguish severity: 0%, 1-25%, 26-50%, 51-75%, 76-100%. Percentage is number of device pairs that had exceptions versus total number of device pairs that have data. If a single device pair is listed in more than one SLA within the SLC, that device pair is counted for each occurrence. Color-coded: Green = no threshold violations; Red = threshold violations.
Device Pairs With Valid Data	Noted as a percentage. Includes total number of device pairs plus device pairs with valid data [For example (0/9) represents 9 device pairs of which 0 has valid data].
Enabled	Determines if SLC enabled. Yes = enabled; No = disabled. Enabled function is selected in Define SLC window.

1Exceptions are based on valid data that exceed defined threshold settings.

Step 4 Click Print to print the SLC Summary Report (optional).

---

Note Only the bottom frame prints when you click Print.

---

---

Generating an SLC Detailed Report

The SLC Detailed Report is a high-level exceptions report for all SLAs contained within that SLC. The report lists an IP address or host name, and any exceptions for each SLA.

Note When requesting reports for the first time, there is a delay resulting from the Java Server Pages (JSPs) compiling.

Procedure

Table 4-3 defines SLC Detailed Report Page elements.

Table 4-3: SLC Detailed Report Page Elements and Descriptions

Element	Description
Top frame	Displays Java reports browser for selecting a folder, SLC, or SLA report.
Bottom frame	Displays an HTML report varying according to what was selected in the top frame.
Heading	Indicates you are in report browser and viewing SLA Summary Report. This is the type of report shown when you select an SLA from the selector. The heading is updated depending on the report selection.
Refresh	Reloads navigation tree from server and returns window to default settings.
Edit SLC	Takes you to Define SLC window. If you do not have appropriate privileges, this element is grayed out.
Help	Opens online help for this window.
Browse selector	Displays hierarchical representation of folders, SLCs, SLAs, and device pairs. What you select determines what report is retrieved and displayed in bottom frame. Device pairs shown in this selector display host name and domain name.
Select Report Date selector	Enables you to choose daily, weekly, or monthly reports. There are 31 daily reports, 12 monthly reports, and 2 yearly reports. Lists are sorted in reverse chronological order.
Go button	Uses context selected in top frame, retrieves desired report, and displays resulting HTML page in bottom frame. Grayed out until you change time or report context (for example, nongray indicates to click for bottom frame contents to match currently selected time and report context).

The SLC Detailed Report is displayed in the bottom frame, as shown in Figure 4-4.

Table 4-4 defines SLC Detailed Report elements.

Table 4-4: SLC Detailed Report Elements and Descriptions

Element	Description
Report frame heading	Indicates context of current screen frame. Upper context is committed when you click Go. Only bottom frame is printed if you click Print.
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
SLC name	Displays user-defined SLC name.
SLA name	Displays SLA name(s) and device pair(s) being monitored. Clicking the device pair(s) link generates SLA detailed report.
Exceptions	Displays any of the following: Exception type and number of threshold violations. For example, latency = 4, max = 72.917[50.0] means: 4 threshold violations involving latency 72.917 ms = maximum threshold violation value during critical time period monitored [50.0] = threshold set to 50.0 ms None = no threshold violations. No valid data = unable to collect data or data all invalid. No exception noted.

The SLC detailed report lists each SLA contained within the selected SLC, along with high-level exception information.

---

Note Clicking an SLA link listed in the bottom frame generates an SLA detailed report. You can also generate an SLA detailed report by selecting the desired SLA or SLA device pair using the Browse selector, selecting the report type, then clicking Go.

---

Step 4 Click Print to print the SLC Detailed Report (optional).

---

Note Only the bottom frame prints when you click Print.

---

---

Generating an SLA Summary Report

The SLA Summary Report displays a high-level exceptions report for all SLAs within an SLC. If you click on an SLC, then select a report type, the bottom frame displays averaged exception information for each SLA contained within that SLC.

Note When requesting reports for the first time, there is a delay resulting from the Java Server Pages (JSPs) compiling.

Procedure

Table 4-5 defines SLA Summary Report Page elements.

Table 4-5: SLA Summary Report Page Elements and Descriptions

Element	Description
Top frame	Displays Java reports browser for selecting a folder, SLC, or SLA report.
Bottom frame	Displays an HTML report varying according to what was selected in the top frame.
Heading	Indicates you are in report browser and viewing SLA Summary Report. This is the type of report shown when you select an SLA from the selector. The heading is updated depending on the report selection.
Refresh	Reloads navigation tree from server and returns window to default settings.
Edit SLC	Takes you to Define SLC window. If you do not have appropriate privileges, this element is grayed out.
Help	Opens online help for this window.
Browse selector	Displays hierarchical representation of folders, SLCs, SLAs, and device pairs. What you select determines what report is retrieved and displayed in bottom frame. Device pairs shown in this selector display host name and domain name.
Select Report Date selector	Enables you to choose daily, weekly, or monthly reports. There are 31 daily reports, 12 monthly reports, and 2 yearly reports. Lists are sorted in reverse chronological order.
Go button	Uses context selected in top frame, retrieves desired report, and displays resulting HTML page in bottom frame. Grayed out until you change time or report context (for example, nongray indicates to click for bottom frame contents to match currently selected time and report context).

The SLA Summary Report for the report type selected displays averaged exception information for all SLAs within that SLC. The report information appears in the bottom frame, as shown in Figure 4-6.

Table 4-6 defines SLA Summary Report elements.

Table 4-6: SLA Summary Report Elements and Descriptions

Element	Description
Report frame heading	Indicates context of current frame. Context is committed when you click Go. Only bottom frame is printed if you click Print.
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
Device Pairs	Displays user-defined device pairs. Clicking device pair link opens detailed report for that device pair.
Exceptions	Displays exceptions that occurred in selected time frame (the number of device pairs in SLA with any exception noted). Uses 5 icons to graphically distinguish severity: 0%, 1-25%, 26-50%, 51-75%, 76-100%. Percentage is number of device pairs that had exceptions versus total number of device pairs. If a single device pair is listed in more than one SLA within the SLC, that device pair is counted for each occurrence.

---

Note Clicking a device pair listed in the bottom frame generates an SLA detailed report. You can also generate an SLA detailed report by selecting the desired SLA or SLA device pair using the Browse selector, selecting the report type, then clicking Go.

---

Step 4 Click Print to print the SLA Summary Report (optional).

---

Note Only the bottom frame prints when you click Print.

---

For SLA detailed report information, see the section "Generating an SLA Detailed Report".

Generating an SLA Detailed Report

The SLA Detailed Report displays specific information for a selected SLA device pair.

Note When requesting reports for the first time, there will be a delay resulting from the Java Server Pages (JSPs) compiling.

Procedure

Table 4-7 defines SLA Detailed Report Page elements.

Table 4-7: SLA Detailed Report Page Elements and Descriptions

Element	Description
Top frame	Displays Java reports browser for selecting a folder, SLC, or SLA report.
Bottom frame	Displays an HTML report varying according to what was selected in the top frame.
Heading	Indicates you are in report browser and viewing SLA Summary Report. This is the type of report shown when you select an SLA from the selector. The heading is updated depending on the report selection.
Refresh	Reloads navigation tree from server and returns window to default settings.
Edit SLC	Takes you to Define SLC window. If you do not have appropriate privileges, this element is grayed out.
Help	Opens online help for this window.
Browse selector	Displays hierarchical representation of folders, SLCs, SLAs, and device pairs. What you select determines what report is retrieved and displayed in bottom frame. Device pairs shown in this selector display host name and domain name.
Select Report Date selector	Enables you to choose daily, weekly, or monthly reports. There are 31 daily reports, 12 monthly reports, and 2 yearly reports. Lists are sorted in reverse chronological order.
Go button	Uses context selected in top frame, retrieves desired report, and displays resulting HTML page in bottom frame. Grayed out until you change time or report context (for example, nongray indicates to click for bottom frame contents to match currently selected time and report context).

Step 2 Select one of the following:

• Daily Reports---Lists data for the past 31 days
  
• Monthly Reports---Lists data for the past 12 months
  
• Yearly Reports---Lists data for the current year or the year prior
  

Step 3 Using the drop-down list box, select the desired time increment for the report type selected, then click Go.

The SLA Detailed Report for that SLA or SLA device pair is generated in the bottom frame.

Step 4 Click Print to print the SLA Detailed Report (optional).

---

Note Clicking Print generates a printable HTML page; you must click Print again.

---

For exception information for a specific operation type, refer to the specific operation type detailed report information, as listed in the section "Related Topics".

---

Related Topics

• Understanding DNS Detailed Report Exceptions

• Understanding HTTP Detailed Report Exceptions

• Understanding ICMP Echo Detailed Report Exceptions

• Understanding UDP Echo Detailed Report Exceptions

• Understanding VoIP Detailed Report Exceptions

Understanding SLA Detailed Report Exceptions

The SLA detailed report includes summary information, and color-coded bar graphs and symbols.

Table 4-8 defines general summary information included in the detailed reports.

Note For color-coded graphs and symbol explanations, see each specific SLA operation type.

Table 4-8: SLA Detailed Report Summary Information Elements and Descriptions - Left Frame

Element	Description
SLA Applied	Applied dates and times as defined in Define SLC window for monitoring threshold violations.
Round-Trip Latency	Value in milliseconds (ms) noting maximum hourly delay, minimum hourly delay, and overall average delay.
Availability1	Amount of uptime (shown as a percentage) for both link and device, and total availability. Denotes network status. Link up = green. If network down, green displays white gaps. Device up = red horizontal line. If device down, line drops. Gray = Critical time period SLA monitored. Displays 24 hours in daily report; 31 days in monthly report; 12 months in yearly report. Note Availability inapplicable for HTTP and VoIP operations.
MTBF2	Value for both link and device. Average elapsed time before a hardware component fails and requires service. (No thresholds monitored.)
MTTR2	Value for both link and device. Average elapsed time to repair hardware component.

1Inapplicable for HTTP and VoIP operations. 2Inapplicable for HTTP and VoIP operations.

---

Note Although a daily report might show that thresholds were reached or surpassed on more than one occasion, the monthly report might not show that thresholds were exceeded at all. This is because averages are used for summary information.

---

Understanding ICMP Echo Detailed Report Exceptions

The SLA detailed report for ICMP echo displays averaged exception information for the SLA device pair listed within that SLA, as shown in Figure 4-8 and Figure 4-9.

Table 4-9 defines SLA Detailed Report elements.

Table 4-9: SLA Detailed Report Elements and Descriptions

Element	Description
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print report information.
SLA Applied	Applied dates and times as defined in Define SLC window for monitoring threshold violations.
Round-Trip Latency	Displays actual data versus threshold in milliseconds (ms). Applied time periods have hour indicators grayed. Maximum and minimum hourly average latency values are also listed in the summary. These correspond to biggest and smallest bars shown on graph.
Availability	Displays actual data versus threshold as a percentage. Apply time periods have hour indicators grayed. Link up versus device up shown in different colors on graph. Daily report-Green =link up; when link down, shows white gaps. Red line = device up; when device down, red line drops. Monthly and yearly reports show color-coded vertical bars. Red = threshold violation; Blue = average/normal.
MTBF	Mean Time Between Failures-Average elapsed time before a hardware component fails and requires service. (No thresholds monitored.)
MTTR	Mean Time to Repair-Average elapsed time to repair a hardware component. (No thresholds monitored.)

Table 4-10 defines ICMP echo errors and descriptions.

Table 4-10: ICMP Echo Error Description

Element	Description
Disconnected	Operation did not occur as target connection lost.
Timeout	Operation timed out. No completion time recorded.
Busy	Operation did not occur as previous operation still outstanding.
Not connected	Operation did not occur as no connection exists with target device.
Verify error	Completed operation received, but data did not match expected data. No completion time recorded.
Error	Other errors not relevant to actual operation (for example, socket failure).
Dropped	Operation did not occur due to lack of internal resources on source device.

Understanding UDP Echo Detailed Report Exceptions

The SLA detailed report for UDP echo displays averaged exception information for the SLA device pair listed within that SLA, as shown in Figure 4-10 and Figure 4-11.

Table 4-11 defines SLA detailed report elements.

Table 4-11: SLA Detailed Report Elements and Descriptions

Element	Description
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
SLA Applied	Applied dates and times as defined in Define SLC window for monitoring threshold violations.
Round-Trip Latency	Displays actual data versus threshold in milliseconds (ms). Applied time periods have hour indicators grayed. Maximum and minimum hourly average latency values are also listed in the summary. These correspond to biggest and smallest bars shown on graph.
Availability	Displays actual data versus threshold as a percentage. Apply time periods have hour indicators grayed. Link up versus device up shown in different colors on graph. Daily report-Green =link up; when link down, shows white gaps. Red line = device up; when device down, red line drops. Monthly and yearly reports show color-coded vertical bars. Red = threshold violation; Blue = average/normal.
MTBF	Mean Time Between Failures-Average elapsed time before a hardware component fails and requires service. (No thresholds monitored.)
MTTR	Mean Time to Repair-Average elapsed time to repair a hardware component. (No thresholds monitored.)

Table 4-12 defines UDP echo errors and descriptions.

Table 4-12: UDP Echo Error Description

Element	Description
Disconnected	Operation did not occur as target connection lost.
Timeout	Operation timed out. No completion time recorded.
Busy	Operation did not occur as previous operation still outstanding.
Not connected	Operation did not occur as no connection exists with target device.
Verify error	Completed operation received, but data did not match expected data. No completion time recorded.
Error	Other errors (for example, socket failure) not relevant to actual operation.
Dropped	Operation did not occur due to lack of internal resources.

Understanding DNS Detailed Report Exceptions

The SLA detailed report for DNS displays averaged exception information for the SLA device pair listed within that SLA, as shown in Figure 4-12 and Figure 4-13.

Table 4-13 defines SLA Detailed Report elements.

Table 4-13: SLA Detailed Report Elements and Descriptions

Element	Description
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
SLA Applied	Applied dates and times as defined in Define SLC window for monitoring threshold violations.
Round-Trip Latency	Displays actual data versus threshold in milliseconds (ms). Applied time periods have indicators grayed. Maximum and minimum hourly average latency values are also listed in the summary. These correspond to biggest and smallest bars shown on graph.
Availability	Displays actual data versus threshold as a percentage. Applied time periods have hour indicators grayed. Link down versus device down is shown in different colors on graph.
MTBF	Mean Time Between Failures-Average elapsed time before a hardware component fails and requires service. (No thresholds monitored.)
MTTR	Mean Time to Repair-Average elapsed time to repair a hardware component. (No thresholds monitored.)

Table 4-14 defines DNS errors and descriptions.

Table 4-14: DNS Error Description

Element	Description
Timeout	Operation timed out. No completion time recorded.
Busy	Operation did not occur. Previous operation still outstanding (for example, rtr router too busy to sample).
Dropped	Operation did not occur due to lack of internal resources.
Verify error	Completed operation received but data did not match expected data. No completion time recorded.
DNS server timeout	DNS server timed out.
DNS query error	Unknown address.
Error	Other errors (for example, socket failures).

Understanding HTTP Detailed Report Exceptions

The SLA Detailed Report for HTTP displays averaged exception information for the SLA device pair listed within that SLA, as shown in Figure 4-14 through Figure 4-17.

Table 4-15 defines SLA detailed report elements.

Table 4-15: SLA Detailed Report Elements and Descriptions

Element	Description
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
SLA Applied	Applied dates and times as defined in Define SLC window for monitoring threshold violations.
Total HTTP Latency	Stacks DNS lookup component, TCP connect component, and Page download component to display total http latency statistics. Displays actual data versus threshold in milliseconds (ms). Applied time periods have hour indicators grayed. Maximum and minimum hourly average latency values are also listed in summary. These correspond to biggest and smallest bars shown on graph.
DNS Lookup Component	Displayed as cyan vertical bar. (See Table 4-16 for error descriptions.)
TCP Connect Component	Displayed as aqua vertical bar. (See Table 4-16 for error descriptions.)
Page Download Component	Displayed as lavender vertical bar. (See Table 4-16 for error descriptions.)

Table 4-16 defines HTTP errors and descriptions.

Table 4-16: HTTP Error Description

Element	Description
Multiple error	More than one error condition occurred.
DNS server timeout	Request unable to connect to DNS server.
TCP connect timeout	Request unable to connect to HTTP server.
Transaction timeout	Request timed out during HTTP transaction.
DNS query error	Request had DNS query error.
HTTP error	Request had HTTP error while downloading base page.
Error	HTTP operation not initiated due to internal error.
Busy	HTTP operation not initiated due to previous HTTP operation not completed.

Understanding VoIP Detailed Report Exceptions

The SLA detailed report for VoIP displays averaged exception information for the SLA device pair listed within that SLA, as shown in Figure 4-18 through Figure 4-22.

Table 4-17 defines SLA Detailed Report elements.

Table 4-17: SLA Detailed Report Elements and Descriptions

Element	Description
Back button	Takes you to previous page.
Print button	Generates an HTML printable page, from which you can print.
SLA Applied	Applied dates and times as defined in Define SLC window for monitoring threshold violations.
Forward Jitter	Interpacket delay variance (difference between interpacket arrival and departure) from source device to target device. Blue bar = average jitter; Red = threshold violation; Blue horizontal line = threshold setting; and Candlestick = vertical bar represents "average" jitter values. Wick represents "maximum" jitter value for period. (See Table 4-18 for error descriptions.)
Backward Jitter	Interpacket delay variance (difference between interpacket arrival and departure) from target device to source device. Blue bar = average jitter; Red = threshold violation; Blue horizontal line = threshold setting; and Candlestick = vertical bar represents "average" jitter values. Wick represents "maximum" jitter value for period. (See Table 4-18 for error descriptions.)
Round-Trip Latency	Blue bar = average latency; Red = threshold violation; Blue horizontal line = threshold setting; and error information noted as *. (See Table 4-18 for error descriptions.)
Forward Packet Loss	Packet loss from source device to target device. Blue bar = average latency; Red = forward packet loss; Blue horizontal line = threshold setting. (See Table 4-18 for error descriptions.)
Backward Packet Loss	Packet loss from target device to source device. Blue bar = average latency; Red = backward packet loss; Blue horizontal line = threshold setting. (See Table 4-18 for error descriptions.)

Table 4-18 defines VoIP errors and descriptions.

Table 4-18: VoIP Error Description

Element	Description
Multiple errors	More than one error occurred.
Packet out of sequence	Number of packets arrived out of sequence.
Packet MIA1	Number of packets lost. Unable to determine direction.
Packet late arrival	Number of packets arrived after timeout.
Error	Number of times jitter operation not initiated due to internal error.
Busy	Number of times jitter operation not initiated due to previous jitter operation not completed.

1MIA = missing in action.

---

Note Although VoIP can provide samples every minute, data is displayed as an averaged hourly value.

---

Posted: Mon Jun 5 14:37:01 PDT 2000
Copyright 1989 - 2000©Cisco Systems Inc.