Hp 3PAR System Reporter Software Uživatelský manuál Strana 1

HP 3PAR System Reporter 2.9 SoftwareUser’s GuideAbstractThis guide provides the information you need to install and use HP 3PAR System Reporter to mon

Object Selection...85Select PDIDs...

It is also possible to retain a chart for further reference. This can be done by moving the chart andthe data sheet linked to that chart to new worksh

NOTE: The Visual Basic code for the Excel client is password protected to prevent accidentalmodification. For customers who would like to add their ow

To create a custom chart with the Percent spare used column in Excel 2003:1. On the Dly PDSpace (1) sheet, click and drag to select the Time column (h

6 Interpreting Report MetricsThis chapter describes the metrics that are shown for each of the various reports generated throughSystem Reporter.Summar

Table 43 Summary Report Metrics (continued)DescriptionMetricShows all TPVVs.TPVVsShows all virtual copies.Virtual CopiesNumber of Host Ports on which

Table 43 Summary Report Metrics (continued)DescriptionMetricTotal (reads + writes) average IO size in KBytes to PDs.PD Total IOSz KByte/sTotal (reads

Space ReportsThis section describes the metrics that are shown for the Physical DIsk (PD), Common ProvisioningGroup (CPG), Logical Disk (LD), and Virt

Table 45 CPG Space Usage Types (continued)DescriptionUsage TypeAmount of admin free space available for CPG allocation.Admin Free Space GiBAmount of r

Table 47 VV Space Report Metrics (continued)DescriptionMetricSpace that is reserved for Snap Space for the selected VVs (Snap Used Space + Snap FreeSp

Table 48 Performance Metrics for PD, Port, LD and VLUN Performance Reports (continued)DescriptionMetricAverage total (read + write) service time in mi

CPU Performance Reports...110Link Performance Reports..

Table 50 Node Cache Performance Report MetricsDescriptionMetricNumber of reads that hit in the cache.Read HitsNumber of reads that miss in the cache.R

Table 52 Link Performance Report MetricsDescriptionMetricTransfers per second on the link.Transfers/sBandwidth used on the link.BandwidthAverage size

7 Configuring the System Reporter Policy SettingsThis chapter describes how to edit HP 3PAR System Reporter policies, such as editing the s amplingpol

Table 54 Sampling Policies (continued)DefaultPolicy24Default number of hours to keep hi-res samples (in force by default for all systemsunless specifi

} )NOTE: Please note that System Reporter does not support using Microsoft SQL with Linux systems.Editing Sampling PoliciesTo edit a System

Figure 46 Connection Dialog BoxNOTE: See for more instructions on setting Apache HTTP Server to require a username andpassword in order to edit sampli

2. Click on Policy Settings in the Extras Menu area.The System Reporter Policies window appears.3. Choose the InServ Systems tab.4. Click Remove InSer

Adding an Alert RuleTo add an alert rule:1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR SystemReporter Web server sc

Removing an Alert RuleTo remove an alert rule:1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR SystemReporter Web serv

Table 55 Data Table (continued)DescriptionData TableRepresents the aggregation of all the SSD PDs of speed 150 in the HP 3PAR Storage System.statpd_ss

charttab...132values:...

Table 57 Metric (continued)Data TablesDescriptionMetricsnlstatpd_ssd150sum, statld, statvlunstatport, statport_nodesum,nlRead KBytes/secread_kbpsstatp

Table 57 Metric (continued)Data TablesDescriptionMetricsstatcpuPercentage idle time for the nodeidle_percstatport, statpd,nlTotal utilization per seco

Figure 48 Example of an alert emailThe email shows that a single VLUN instance had an average total service time of 2098.800680millisec during a high-

Adding a Scheduled ReportTo add a scheduled report:1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR SystemReporter Web

Removing a Scheduled ReportTo remove a scheduled report:1. Point your browser at the Web server where Apache HTTP Server and the HP 3PAR SystemReporte

-rwxr-xr-x 1 apache apache 6717686 Jan 21 23:49 inserv_perf.exe-rwxr-xr-x 1 apache apache 1211700 Jan 21 23:49 chart.exels -ltra /var/www/cgi-bin/3par

8 Web QueriesThis chapter documents the queries that the HP 3PAR System Reporter interfaces make to the SystemReporter Web server.About Web QueriesSys

where <server_name> is the name of your server. The following is an example of the tablereturned:Figure 50 System Reporter Version ReportThis qu

Report OptionsOptions are included in the query URL by using the following syntax:<option>=<value>where <option> and <value> a

DiskTypeCompares selected disk types. This value is only available for the pd_perf_time,ld_space_time and pd_space_time reports.DiskSpeedCompares sele

value:...144example:...

Compares selected disk magazine position. This value is only available for the pd_space_timereport.example:The following example specifies that all lo

The virtual size.tableUse the table option to specify a table from which data is returned when using one of theobjects_present reports (see “Objects P

example:The following example specifies that the report is to be reloaded every 2 minutes:&refresh=2charttabUse the charttab option to specify whe

Specifies that charts will use stacked vertical bars. Stacked charts stack data on top of each otherso you can see the total as well. See Figure 35 (p

graphlegposUse the graphlegpos option to specify the position of the chart legend. If not defined, the legendposition is selected automatically based

example:The following example specifies that all the time axis points should be labelled:&alllabels=1timeformUse the timeform option to specify a

If <tsecs> is non-negative it represents a point in time, expressed as the number of seconds sinceJanuary 1, 1970, GMT. For example, to express

DomainGroup results by domain.HostGroup results by hosts.CPGGroup results by Common Provisioning Group (CPG) name.UsrCPGGroup results by Common Provis

PortTypeGroup results by port type.example:The following example specifies that results should be grouped by system:&groupby=SystemThe following e

PortNodeOrder results by port node number (The n part in n:s:p).RaidTypeOrder results by RAID level (for example, RAID 0, RAID1, RAID 5 and RAID 6).LD

pd_space_time...153example:...

Order results by CPU context switches/sec.VirtSizeOrder results by VV virtual size.TotalRsvdSizeOrder results by VV reserved space size.TotalRawSizeOr

example:The following example specifies that the histogram should include all accesses:&histbegin=1ldspaceunitUse the ldspaceunit option to determ

See “ldspaceunit” (page 141).GiB (2^30 bytes)See “ldspaceunit” (page 141).examples:The following example specifies that the physical disk space unit s

value:Specify one or more of the following:--All cage IDs--(Default). Does not exclude cages based on their cage IDs.<cage_ID>This value consist

SPR_AVAIL_CLEANInclude only spare available (unused) chunklets that have been cleaned (initialized).SPR_AVAIL_DRTYInclude only spare available (unused

selsnpcpgUse the selusrcpg option to select a Common Provisioning Group (CPG) that is used for thesnap space of VVs. Usage and values are similar to s

The following example specifies that only 10K RPM disks are to be included:&seldiskspeed=10seldomainUse the seldomain option to select a domain ac

The following example specifies including only VLUNs exported to host winhost1:&selhost=winhost1The following example specifies including only VLU

Includes only logical disks used for logging.example:The following example includes logical disks of all usage types:&sellduse=The following examp

example:The following example shows two ways to specify that no ports are to be excluded based onlocation:&selnsp=OR&selnsp=--All%20Ports--The

regiondensity example...160regmoves...

example:The following example shows two ways to specify that physical disks are not to be excluded basedon their states:&selpdstate=OR&selpdst

Specify this value to include RAID 1 logical disks.5Specify this value to include RAID 5 logical disks.6Specify this value to include RAID 6 logical d

example:The following example shows two ways to specify that volumes be included regardless of name:&selvv=OR&selvv=--All%20VVs--The following

Report TypesReport types are identified with names that typically use the following format:<object>_<yaxis>_<xaxis>where• <object

selcageid=--All%20Cage%20IDs--&seldisktype=--All%20Disk%20Types--&report=pd_space_timepd_space_groupPlots the total number of chunklets of dif

example:The following example shows the entire query string for a vv_space_time report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?charttab=cha

example:The following example shows the entire query string for a pd_perf_group report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?charttab=cha

example:The following example shows the entire query string for a port_perf_group report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?category=d

example:The following example shows the entire query string for a ld_perf_group report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?charttab=cha

example:The following example shows the entire query string for a vlun_perf_group report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?charttab=c

Selecting an HP 3PAR Storage System for Adaptive Optimization...179Configuring Adaptive Optimization...

tsecs=&selsys=--All%20Systems--&selvv=--All%20VVs--&groupby=System&orderby=System&report=vv_cmp_groupcpu_perf_timeReturns a chart

regmoves exampleThe following example shows the entire query string for a regmoves report:http://localhost/cgi-bin/3par-rpts/inserv_perf.exe?charttab=

Figure 51 Valid Options for Summary, Space and Adaptive Optimization Reports (I)162 Web Queries

Figure 52 Valid Options for Summary, Space and Adaptive Optimization Reports (II)Options Available by Report 163

Figure 53 Valid Options for Summary, Space and Adaptive Optimization Reports (III)Figure 54 Valid Options for Performance Reports (I)164 Web Queries

Figure 55 Valid Options for Performance Reports (II)Options Available by Report 165

Figure 56 Valid Options for Performance Reports (III)Figure 57 Valid Options for Performance Reports (IV)166 Web Queries

Objects Present ReportsObjects present reports return the objects present in a table over a specified time for use in userinterface controls. For exam

Table 58 Objects Present Report table values (continued)table valuesReportldspacenlobjects_present&“objectpres= domain_name”(page 171)objectpres=

objects_present&objectpres=cageidhttp://localhost/cgi-bin/3par-rpts/inserv_perf.exe?report=objects_present&objectpres=cageid&table=pdspace

The statlink Table...212The statlinkinv Tabl

objectpres= diskspeedReturns a list of disk speeds.example:The following example shows the entire query string for:objects_present&objectpres=disk

objectpres= domain_nameReturns a list of domain names.example:The following example shows the entire query string for:objects_present&objectpres=d

objectpres= ld_nameReturns a list of logical disk names.example:The following example shows the entire query string for:objects_present&objectpres

objects_present&objectpres=nodehttp://localhost/cgi-bin/3par-rpts/inserv_perf.exe?report=objects_present&objectpres=node&table=statcpu&

objectpres=portReturns a list of ports.example:The following example shows the entire query string forobjects_present&objectpres=porthttp://localh

objectpres= vv_nameReturns a list of virtual volume names.example:The following example shows the entire query string for:objects_present&objectpr

output:Returns a row for each volume present over the time range (excluding snapshot volumes) for eachsystem.Output columns are:• System: system name•

sample_timesReturns valid times of database samples.example:The following example shows the entire query string for:sample_timeshttp://localhost/cgi-b

9 Using Adaptive OptimizationThis chapter provides information about the optionally licensed Adaptive Optimization feature thatworks in conjunction wi

Selecting an HP 3PAR Storage System for Adaptive OptimizationTo begin using Adaptive Optimization on an HP 3PAR Storage System array, you must either

1 IntroductionThis guide provides the information you need to install and use HP 3PAR System Reporter to monitorperformance, create charge back report

3. Click the Adaptive Optimization tab.The Adaptive Optimization Configuration window appears (Figure 60 (page 180)).Figure 60 Adaptive Optimization C

NOTE: When you specify two tiers, for the purposes of analysis and data movement only theorder of the tiers matters, not the actual tier number. For e

except in the case where the CPG is the default for snapshot or base TPVV allocation as noted inthe following caution.CAUTION: For some CPGs, especial

not be optimal. We can achieve optimal results by scheduling adaptive optimization execution for11 am Monday through Friday with a measurement interva

10. When done, click Submit Query. An alert window appears confirming that AdaptiveOptimization configuration has been added.11. Click OK to return to

Figure 61 Region IO Density Showing Total SpaceFigure 62 Region IO Density Showing Total IO AccessEach region is put into the appropriate histogram bu

Figure 63 Region IO Density without Adaptive OptimizationYou can see that much of the space is used for regions with very few IO accesses and most of

Figure 65 VV Tiers ReportAdaptive Optimization Space Moved ReportThe Space Moved report shows the space moved over a selected time interval for each A

report shows the space moved over the selected time interval for each Adaptive Optimizationconfiguration.The showvvcpg CLI extensionAdaptive Optimizat

esx-sysrpt esx-ssd-r1 128 - 7680 - - -esx-sqa esx-fc-r1 384 - 44544 - - -esx-sqa esx-ssd-r1 128 - 1536 - - -esx-sw esx-fc-r1 224 - 249088 - - -esx-sw

Typographical ConventionsThis guide employs the following typographical conventions:ExampleMeaningTypefaceWhen prompted, click Finish tocomplete the i

10 Database SchemaThis chapter documents the HP 3PAR System Reporter database schema.Using The Database SchemaThe description of the database schema i

Table 60 sampleinserv_5 TableCommentTypeColumnIP address of the system to sample.VARCHAR(64) NOTNULLnameDetermines whether CLI connections to the InSe

Table 61 system_4 Table (continued)CommentTypeColumnSystem hardware model, for example:VARCHAR(32) NOTNULLsystem_modelInServ S400XInServ T400Indicates

Table 62 alertconfig_2 Table (continued)CommentTypeColumnDefines an additional condition that must be met for certain alertsto be generated. See “Cond

Table 65 adprovconfig_1 TableCommentTypeColumnA unique identifier for each adaptive optimization configuration.INTEGER PRIMARY KEY(AUTO_INCREMENT)adpr

Table 67 ldrgmoves_1 TableCommentTypeColumnTime in secs when the LD region move was scheduled. This is theUnix time and is the number of seconds since

Table 68 recentsample_1 TableCommentTypeColumnThe sample resolution, one of hires, hourly or daily.VARCHAR(32) NOT NULLresolutionSample time in secs o

Table 69 pdspace_<res>_3 Table (continued)CommentTypeColumnNumber of normal unused chunklets that have been initialized.These are free for use i

The ldspace TableThe ldspace_<res>_3 table holds logical disk (LD) space data samples.Table 71 ldspace_<res>_2 TableCommentTypeColumnSampl

Table 72 ldspaceinv_<res>_2 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number of secondssince 0:00:00 Jan 1, 19

© Copyright 2011 Hewlett-Packard Development Company, L.P.The information contained herein is subject to change without notice. The only warranties fo

2 Overview and FeaturesThis chapter provides a brief overview of the features and capabilities offered by System Reporter.About System ReporterSystem

Table 73 vvspace_<res>_3 Table (continued)CommentTypeColumnThe provisioning type of the VV (see the Prov column for the showvv CLIcommand in InF

Table 73 vvspace_<res>_3 Table (continued)CommentTypeColumnRaw (physical space including RAID overhead) user space reserved for theVV in MB.DOUB

Table 75 cpgspace_<res>_1 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number of secondssince 0:00:00 Jan 1, 1970

The cpgspaceinv TableThe cpgspaceinv_<res>_1 table holds the inventory for the cpgspace_<res>1 table.Table 76 cpgspaceinv_<res>_1 Ta

Table 77 Common Performance Columns (continued)CommentTypeColumnTotal number of bytes read since the object was first created orrestartedDOUBLE PRECIS

Table 77 Common Performance Columns (continued)CommentTypeColumnNumber of writes in service time bucket number 0.DOUBLE PRECISIONNOT NULLwhist0Differe

Table 78 Common Performance Metrics for a Sample Row (continued)SQL ExpressionMetricCASE WHEN d_now > 0 THEN d_wbytes * 1000.0/d_now ELSE 0 ENDWrit

Table 79 statpd_<res>_4 Table (continued)CommentTypeColumnThe PCI slot in the node that the disk’s primary port is connected to (the“s” part of

Table 81 statld_<res>_5 Table (continued)CommentTypeColumnThe node that owns the LDINTEGER NOT NULLnodeThe name of the CPG that the LD belongs t

Table 83 statport_<res>_4 Table (continued)CommentTypeColumn• iscsi - iSCSI host ports.• free - ports that are not connected.The rest of the col

• Alert Rules -- Used to add, modify and remove alert rules and to specify the parameters forgenerating email reports.• Scheduled Reports -- Used to a

Table 85 statvlun_<res>_3 Table (continued)CommentTypeColumnThe host WWN (world wide name) or iscsi name.VARCHAR(128) NOTNULLhost_wwnThe node th

Table 87 statvvcmp_<res>_2 Table (continued)CommentTypeColumnThe VV name.VARCHAR(32) NOT NULLvv_nameThe number of read cache hits for the VV.DOU

Table 89 statcpu_<res>_1 Table (continued)CommentTypeColumnDifference between usert value from last sample for same CPU.DOUBLE PRECISION NOTNULL

Table 91 statlink_<res>_2 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number ofseconds since 0:00:00 Jan 1, 1970

Table 93 statldrg_hourly_2 TableCommentTypeColumnSample time in secs. This is the Unix time and is the number ofseconds since 0:00:00 Jan 1, 1970 GMT.

11 TroubleshootingThis chapter describes how to troubleshoot and solve common problems that may occur whilesetting up or using System Reporter.Trouble

When reporting a problem with sampling, please provide the entire log directory.CAUTION: If you get an error in a sampling component that causes the s

Errors incurred by the CLI sampler process.Errors incurred by the CLI sampler process may include loss of network connectivity to the HP 3PARStorage S

Figure 67 Microsoft Office Excel Internal ErrorIf you experience a problem with a recovered copy of the workbook (Figure 68 (page 218)), trystarting w

-dbhost <dbhost> For mysql: name or IP address of host. Default is localhost. For orac

Table 1 Available Reports (continued)Report Metrics Cross ReferenceDescriptionReport Name“Common Performance Metrics” (page 108).Displays VLUN(volume-

From MS SQL to SQLite:sysbck -dbtype mssql -dbhost istat -db cliuser -dbpwfile dbpwfile -dbouttype sqlite -scripttype both -backupfilename "c:/te

• From SQLite to MS SQL:sysbck -dbtype sqlite -db cliuser -dbouttype mssql -scripttype both -backupfilename "c:/test/test_20100713_1322PM" -

NOTE: When executing sysbck.exe from any other directory on Windows, ensure that thePATH environment variable is set to the System Reporter root direc

IndexSymbols3PAR System Reporter User’s Guide, 543PAR System Reporter.xls, 493par-policy subdirectory, 1253par-rpts subdirectory, 125Aadding a system

Port Performance Reports, 21Rreading of the database, 49Red Hat Enterprise Linux, 25Region IO Density Report, 184related documentation, 18remove a sto

• Object Selection – Selects the list of objects that are to be included in the reporting data. Forexample, you can select the VVs, ports and hosts fo

together in a single web page. You can do this by creating an html file that includes multiple iframeelements, each of which includes a standard web r

3 Installation, Configuration, Update, and RemovalThis chapter describes how to install and configure as well as remove the HP 3PAR System Reportercom

Table 2 InServ Storage Server CD Contents (continued)DescriptionFilenameDirectorySystem Reporter installer executable for Microsoft Windows.installer.

Table 4 HP 3PAR Storage System Requirements (continued)Additional RequirementsSupported Operating SystemsComponentInForm OS version 2.3.1 MU1 andbeyon

Figure 1 System Reporter Sizing Spreadsheet1. Click on the appropriate type of database that you are using for System Reporter at your site.You will n

Figure 2 HP 3PAR Storage System and User Interface Components• Database. The HP 3PAR System Reporter database is capable of supporting SQL queries.Fou

Apache HTTP Server Copyright & LicenseLicensed under the Apache License Version 2.0, January 2004, http://www.apache.org/licenses/TERMS AND CONDIT

• Web server components. The HP 3PAR System Reporter Web server has customized scriptsthat access the database to generate reports to standard browser

Figure 3 Installation Process FlowchartInstalling the Web ServerHP 3PAR System Reporter requires Apache HTTP Server, version 2.2 or later.A copy of th

NOTE: System Reporter 2.9 and beyond supports secure connections on Apache servers usingthe SSL protocol. For details on implementing the SSL protocol

the sampler or the Web server can time out. Furthermore, database compaction (see “CompactingDatabases” (page 113)) cannot be done in parallel with sa

Table 5 Database Comparison (continued)OracleMySQLMicrosoft SQLSQLiteCommentYesYesYesNoScale to large number ofconcurrent users?GoodHighGoodAdequate f

1. Select Administrative Tools→Data Sources (ODBC).The ODBC Data Source Administrator screen appears:Figure 5 ODBC Data Source Administrator Screen2.

Figure 7 Create a New Data Source to SQL Server ScreenNote that the screens appear somewhat differently depending on whether you have chosento use the

7. Enter the user's log in and password information, then click Next.Figure 9 Specifying the MSSQL Database Name8. Check the Change the default d

Figure 11 ODBC Microsoft SQL Server Setup Screen.11. Check the details for the selected database, then click Test Data Source.The screen must show the

NOTE: Beginning with the 2.2 release, System Reporter can use a MySQL database on a remoteserver. The MySQL installation and configuration steps are t

wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do notmodify the License. Y

10. Confirm that Modify Security Settings is selected, enter a root password, and then retype thepassword to confirm.CAUTION: Be sure to record the pa

These users have different privilege levels that correspond with optional Apache HTTP Serverprivilege levels, as described in “Installing or Upgrading

10. After clicking Finish, check the settings in the confirmation screen and click OK.11. Click Exit after the database has been created.Creating the

2. Start the Net Configuration Assistant.3. Select the Local Net Service Name Configuration radio button and click Next.4. Select the Add radio button

3. When prompted, use the Browse... button to select and enter the full path to the InForm CLIexecutable cli.exe (if it is different from the default)

Alerts” (page 116)) you may leave all entries in this screen blank. If you want to be able toconfigure System Reporter to generate email alerts, you m

Installing System Reporter Tools on LinuxSystem Reporter tools on Linux consists of two RPM packages available on the CD:• sampleloop (sampleloop-2.9-

6. Install the sysrptwebsrv package by mounting the System Reporter CD, changing to the directoryon the CD that includes the rpm packages and running:

• Days to keep Daily Data -- Specifies the number of days to retain daily data.• Days to keep Adaptive Optimization Data -- Specifies the number of da

NOTE: Use of the HP 3PAR System Reporter Excel client requires that you have Microsoft® Excel®2003 or 2007 software already installed on your local ma

When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have thefreedom

distinction between users with database and sampling policy read access and those with databasesampling policy edit privileges. Note that, when adding

6. Using Windows Explorer, go to the location where you installed the HP 3PAR System Reportertools (for example, C:\Program Files\3par\System Reporter

4 Getting StartedThis chapter describes how to start using HP 3PAR System Reporter from the primary web interfaceor Excel client.NOTE: For information

Figure 14 The System Reporter Main WindowThe HP 3PAR System Reporter Main Menu (Figure 14 (page 53)) is divided into the followingareas:• Title Pane w

◦ User Guide (this document in PDF format).◦ Sampling Status (the time since the most recent high-resolution sample for each systembeing sampled).NOTE

The list of available objects can be filtered by typing an expression pattern in the text input areaabove the list of available objects and clicking o

Figure 15 System Reporter Excel ClientSetting the Security Level for ExcelThe HP 3PAR System Reporter Excel client uses macro code to implement its fu

Figure 17 Setting the Security Level3. On the Security Level tab, set the security level to Medium or Low (Medium is the default andsuggested setting)

1. Click the Options button next to the security alert.The Security Alert - Macro screen appears (Figure 18 (page 58)).Figure 18 Macro Security Alert

Figure 19 Trust Center Screen8. If it is not already set, from the list of Macro Settings, choose Disable all macros withnotification.NOTE: The HP 3PA

Accompany it with a written offer, valid for at least three years, to give any third-party, for a charge no more than your cost of physically performi

1. After opening the HP 3PAR System Reporter Excel client workbook with the correct securitylevel setting, click Initialize.The Connection Parameters

Changing the Excel Client Server and Resetting the WorkbookThe HP 3PAR System Reporter Excel client workbook includes a custom 3PAR menu that is acces

Deleting Data SheetsData sheets remain until you manually delete them. Manually deleting a data sheet causes anyembedded charts associated with that d

Figure 22 Security Alerts Multiple IssuesTo enable macros and the data connection, choose the Enable this content buttons.NOTE: If it is ever necessar

5 Accessing and Creating ReportsThis chapter describes how to access quick reports, scheduled reports, and build custom reportsthat are specifically t

Figure 23 Quick Reports WindowAccessing Scheduled ReportsScheduled reports are generated using pre-selected parameters at scheduled times and are stor

Figure 24 Scheduled Reports WindowNOTE: See“Scheduling Reports” (page 122) for complete details on scheduling a report.Creating Custom ReportsYou can

Building the Report MenuThe first step in creating a report is to choose the appropriate options for the type of report thatyou want to generate.Figur

Table 6 Sample ResolutionPurposeOptionChoose the Daily data table, which covers the largest time range, but has the coarsestresolution with only one s

Table 8 Select SystemPurposeOptionThe report will include all the systems that are included in the database.-All Systems-Select one or more systems to

for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the shar

Figure 26 Report Menu for Daily VLUN PerformanceThe top of the report menu includes a section that lists the current selection of systems of domains.I

Use the controls in the menu to select the desired report parameters and then click Generate Report.See for a listing of the controls that are availab

Figure 27 Query ResultsIf necessary, use the scrollbox on the right to view all charts and/or tables.Controls Available by ReportTable 10 (page 73) li

Table 10 Controls for Each ReportAdaptiveOptimizationLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpaceCPGSpacePDSpaceS

Table 10 Controls for Each Report (continued)AdaptiveOptimizationLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpaceCPGS

Table 10 Controls for Each Report (continued)AdaptiveOptimizationLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpaceCPGS

Table 10 Controls for Each Report (continued)AdaptiveOptimizationLinkPerfCPUPerfNodeCachePerfVVCachePerfVLUNPerfLDPerfPortPerfPDPerfVVSpaceLDSpaceCPGS

Table 11 Standard Report Types (continued)PurposeReport TypeThe beginning of the time range is specified by the Begin/At Time control (see“Begin/At Ti

Figure 29 Versus Time with Compare=System Report ExampleIf you want to compare the performance of a particular class of objects (for example, systems)

Figure 30 Group By System:Host At Time Report ExampleThe At Time report can be used in conjunction with the Group By and Order By controls to do mored

Contents1 Introduction...18User Interfaces...

Figure 31 Histogram Versus Time Report ExampleThe Histogram Versus Time report provides a histogram or service times for the aggregate of theselected

Figure 32 Histogram At Time Report ExampleThe Histogram At Time report provides a histogram or service times and IO sizes at a specific timefor the ag

Select Peak control (see section “Max. Number” (page 82)) can be used to select 16 objects tocompare.Max. NumberSpecifies the maximum number of graphs

Table 12 Group By (continued)PurposeOptionGroup by port’s node number (The n in n:s:p).PortNodeGroup by the port (n:s:p).n:s:pOrder ByThis control is

Table 13 Order By (continued)PurposeOptionOrder by total of the selected chunklets for PD space reports.SelChunkSizeOrder by total IOPs.IOPs/sOrder by

Table 14 Begin/At TimePurposeOptionBegin with the earliest sample available.earliestBegin at the specified time value. The values in the menu are popu

Table 18 Include ChunkletsPurposeOptionShow all the chunklet types in the report.-All Chunklets Types-Select one or more chunklet types to include in

Table 22 Include PDs in StatesPurposeOptionInclude all PD in the report.-All PD States-Include PDs in a valid state in the report.validInclude PDs not

Select LDsThis is a filtered multi-selection control (see “Filtered Multi-Selection Control” (page 54)) used toselect one or more LDs to include in th

Table 29 Select LUN UsagePurposeOptionThe report will include all the LUNs that are included in the database.-All LUNs-Select one or more LUNs to incl

About Apache HTTP Server Authorization and Access Control...49Removing the System Reporter Componen

Table 32 Select VV TypesPurposeOptionThe report will include all the VV Types that are included in the database.-All VV Types-Select one or more VV Ty

Select HostsThis is a filtered multi-selection control (see “Filtered Multi-Selection Control” (page 54)) used toselect one or more Hosts to include i

Report InformationFor each report except for the Summary Report, you can use the Report Information pull-down listto choose between displaying query r

You can choose from the following chart types:• Stacked BarsFigure 34 Chart Using Stacked Bars• Stacked Vert BarsCreating Custom Reports 93

Figure 35 Chart Using Stacked Vertical Bars• Stacked AreaFigure 36 Chart Using Stacked Areas• Lines94 Accessing and Creating Reports

Figure 37 Chart Using Lines• BarsFigure 38 Chart Using BarsCreating Custom Reports 95

• Vert BarsFigure 39 Chart Using Vert BarsChart X PixelsYou can explicitly specify the length in pixels of the X (category) axis of charts. If this is

Table 41 Time FormatPurposeOptionTime format is chosen automatically based on the sample resolution. If resolution is Daily, theformat includes the mo

Figure 40 Change Chart Type Menu for the Excel Client4. Choose the appropriate selection from the list of chart types, then select on the chart that y

1. Right-click in any data cell and click Data Range Properties in the shortcut menu that appears.Figure 41 Data Range Properties Shortcut MenuThe Ext