beautypg.com

Formatting reports for presentation, Customizing the reporting format, Generating email alerts – HP 3PAR System Reporter Software User Manual

Page 21: Accessing report data using web queries

background image

Formatting Reports for Presentation

When building customized reports, you can specify how the reporting data is formatted for viewing
by selecting the appropriate table or type of chart. You can choose from the following chart types:

Stacked Bars

Staked Vertical Bars

Stacked Area

Bars

Vertical Bars

In addition to choosing the type of chart that is best suited for the report being generated, you can
also fine tune the presentation by selecting the position of the legend, choosing a time format and
specifying how the units of storage measurement are represented (i.e., MBs, TBs, chunklets, etc.).

When using the Excel client to build reports, you have additional flexibility in the formatting of a
report by modifying the data sheet and including customized columns.

For descriptions and options available for formatting reporting data, see

“Creating Custom Reports”

(page 66)

.

NOTE:

Access to a currently unsupported charting package is also available in this version and

offered as one of the formatting options (under Chart Lib) when generating a report.

To use the unsupported charting capabilities offered through this “Dynamic” charting option, you
must use a browser that supports HTML5 canvas tags (the latest versions of Windows IE9, Firefox
and Google Chrome browsers currently offer this support).

Customizing the Reporting Format

Although System Reporter provides a number of built-in controls for specifying the format of a
report, in some cases you may want to present the data using a different format that is not available
from the standard selection. In this case, you can save the data for the report using the Comma
Separated Values (CSV) format as an option that is accessible with the click of an icon next to the
heading of the report. You can then open the CSV formatted file in an application (such as a
spreadsheet) where it can then be charted or formatted as desired. If the browser is set up to open
files with a .csv extension in a spreadsheet application, this can be done automatically.

Generating Email Alerts

You can configure System Reporter to send email alerts when certain metric meet specified
conditions. For example, suppose you want to receive an email alert when any VLUN has an
average read service time of more than 100 ms in any high-resolution sampling interval. To do
this, all you need to do is fill in a form with the specified details and then submit the query.

For complete details on how to configure email alerts, see

“Configuring Rules for Email Alerts”

(page 120)

.

Accessing Report Data using Web Queries

The querying mechanism employed by System Reporter is made available for specialized
customization of reports. For instance, instead of using the Excel client provided with System
Reporter, you can use web queries in an Excel spreadsheet to bring various report data into your
spreadsheets. As another alternative, you might like to view multiple standard reports presented
together in a single web page. You can do this by creating an HTML file that includes multiple
iframe elements, each of which includes a standard web report query.

See

“Web Queries” (page 129)

for details on how to instigate web queries.

Formatting Reports for Presentation

21