Manuals / Brands / Computer Equipment / Software / HP / Computer Equipment / Software

HP 3PAR System Reporter E-Media Kit, System Reporter Media Kit 5.4.4Exporting Executable Reports

1 378

Download 378 pages, 2.5 Mb

3PAR System Reporter User’s Guide

System Reporter 2.8

2On the shortcut menu, click Location (for Excel 2003) or Move Chart (for Excel 2007). The Chart Location (for Excel 2003) or Move Chart (for Excel 2007) dialog appears.

3In the Chart Location or Move Chart dialog box, click As new sheet or New sheet and then click OK to move the chart to a new sheet.

A new tab (with the specified name) appears at the bottom of the window for the new worksheet that holds the moved chart.

NOTE: Moving a chart may cause it to be resized. When a chart becomes smaller, you can adjust the axis labels to make them more readable. To adjust the axis, right-click the axis, click Format Axis... on the shortcut menu that appears, and then use the controls in the Format Axis dialog box.

4Identify the data sheet that contains the source data for the moved chart. For example, a chart generated with the PDIO reporting tool sheet is linked to data on either the PDSpace Time Data or PDSpace Items Data sheet.

NOTE: If you don’t know the name of the data sheet that holds the source data for a chart, you can right-click the chart and click

Source Data..., then click the Series tab in the Source Data dialog box that appears. On the Series tab, look at the Name and Values boxes. The worksheet name appears in both boxes, just before the exclamation point.

5Right-click the source data sheet tab and click Rename, then edit the data sheet name. Be sure to use a unique name that is not used for any other reporting tool or data sheets in the Excel client workbook.

After editing the data sheet name, you can return to the reporting tool sheet to perform additional queries without affecting the relocated chart or the data sheet holding its source data.

5.4.4Exporting Executable Reports

When working with reports generated through the Excel client, you have the ability to save the contents to a file where the formatted data can be accessed. This is useful when you want to have data in a given report accessible to anyone in a directory or to email the reports. Here are the steps for saving an executable report:

5.56	Working with Excel Charts

Contents

3PAR® System Reporter 2.8 User’s Guide Page Page Page Page Page Page Page Page Page Table of Contents 1 Introduction 2 Overview and Features 3 Installation, Configuration, Update, and Removal 4 Getting Started 5 Accessing and Creating Reports Page Page 6 Interpreting Report Metrics 7 Configuring the System Reporter Policy Settings 8 Web Queries Page Page 9Using Adaptive Optimization 10 Database Schema 11 Troubleshooting IX Index RH Revision History Page 1 Introduction 1.1 Audience 1.2 User Interfaces 1.3Related Documentation 1.4 Organization 1.5 Typographical Conventions 1.6 Advisories Overview and Features 2.1 About 3PAR System Reporter 2.2Configuring System Reporter Policy Settings 2.3 Choosing a Method for Accessing Reports 2.4 Creating Customized Reports Page 2.5 Formatting Reports for Presentation 2.6 Customizing the Reporting Format 2.7 Generating Email Alerts 2.8 Accessing Report Data using Web Queries 2.9 Using the Database Schema to Build Custom Reports 2.10 Analyzing and Optimizing Storage Utilization Installation, Configuration, Update, and Removal 3.1 Before You Begin 3.2 System Reporter CD Contents Page 3.3 System Requirements Page 3.4 Using the System Reporter Sizing Spreadsheet Page Page 3.5 System Reporter Components Page 3.6 Installing the System Reporter Components Page 3.7 Installing the Web Server 3.8 Installing the Database Server 3.8.1 Choosing the Appropriate Database 3.8.1.1 SQLite 3.8.1.2 MySQL 3.8.1.3 Oracle 3.8.2 Installing and Setting Up the MySQL Database (Optional) 3.8.2.1 Installing MySQL Server 3.8.2.2 Configuring the MySQL Database 3.8.2.3 Setting the max_allowed_packet parameter 3.8.2.4 Creating MySQL Users and Schema 3.8.3 Setting Up the Oracle Database (Optional) 3.8.3.1 Creating an Oracle database 3.8.3.2 Creating the Oracle Users for System Reporter 3.8.3.3 Creating the Oracle Net Service 3.9 Installing or Upgrading the System Reporter Tools 3.9.0.1 Installing or Upgrading System Reporter Tools on Windows Page Page Page 3.9.0.2 Installing System Reporter Tools on Linux Page Page 3.9.1 Adding InServ Systems 3.9.1.1 Setting File Permissions (Optional) 3.9.1.2 Verifying Installation 3.10 Installing the Excel Client (Optional) 3.11 About Apache HTTP Server Authorization and Access Control Page 3.12 Removing the System Reporter Components 3.12.1 Removing the System Reporter Tools on Windows 3.12.2Removing the System Reporter Tools on Linux 3.12.3Removing the MySQL Database (Optional) Page Getting Started 4.1 Accessing the Main System Reporter Interface Page 4.2 System Reporter Main Menu Window 4.3 Getting Help 4.4 Using the Object Selection Controls 4.4.1 Simple Selection List 4.4.2 Filtered Multi-SelectionControl 4.5 Accessing the Optional Excel Client 4.5.1 Starting the System Reporter Excel Client 4.5.2 Setting the Security Level for Excel 4.5.2.1 Setting the Security for Excel Page Page 4.5.2.2 Setting the Security Level for Excel Page 4.5.3 Connecting to the Web Server from the Excel Client Page 4.6 Changing the Excel Client Server and Resetting the Workbook 4.6.1 Changing the Web Server 4.6.2Resetting the Workbook 4.7Accessing the Excel Client Query Log 4.8 Deleting Excel Sheets 4.8.1 Deleting Menu Sheets 4.8.2Deleting Data Sheets 4.8.3Deleting the Query Log 4.9Saving and Exiting the Excel Client Page Accessing and Creating Reports 5.1 Accessing Quick Reports 5.2 Accessing Scheduled Reports 5.3 Creating Custom Reports 5.3.1 Building the Report Menu 5.3.1.1 Sample Resolution 5.3.1.2 Report Page 5.3.1.3 Select Systems 5.3.1.4 Select Domains 5.3.2 Generating the Report Page Page Page 5.3.3 Controls Available by Report Page Page 5.3.4 Report Selection 5.3.4.1 Standard Report Types Page Page Page Page Page 5.3.4.2 Select Summary Columns 5.3.4.3 Compare 5.3.4.4 Select Peak 5.3.4.5 Group By Page Page 5.3.4.6 Order By Page 5.3.4.7 Low Bucket 5.3.4.8 High Bucket 5.3.4.9 Sum End Buckets 5.3.5Time Selection 5.3.5.1Reload After (mins) 5.3.5.2 Begin/At Time 5.3.5.3 End Time 5.3.5.4 Count 5.3.6 Object Selection 5.3.6.1 Select PDIDs 5.3.6.2 Include Chunklets 5.3.6.3 Select Cage IDs 5.3.6.4 Select Disk Types 5.3.6.5 Select Disk Speed 5.3.6.6Include PDs in States 5.3.6.7 Select Usr CPGs 5.3.6.8 Select Snp CPGs 5.3.6.9 Select CPGs 5.3.6.10 Select LDs 5.3.6.11 Select RAID Types 5.3.6.12 Select LD Usage 5.3.6.13 Select VVs 5.3.6.14 Select Prov Types 5.3.6.15 Select VV Types 5.3.6.16Select Ports (n:s:p) 5.3.6.17 Select Port Types 5.3.6.18 Select Hosts 5.3.6.19 Select Nodes 5.3.6.20 Select To Nodes 5.3.6.21 Select Queues 5.3.7 Format Selection (Web interface only) 5.3.7.1 Report Information 5.3.7.2 Chart Types Page Page Page 5.3.7.3 Chart X Pixels 5.3.7.4 Chart Y Pixels 5.3.7.5 Time Labels 5.3.7.6 Legend Position 5.3.7.7 Time Format 5.3.7.8 Select Space Unit 5.4 Working with Excel Charts 5.4.1 Choosing a Chart Type 5.4.2 Refreshing Charts Page 5.4.3Retaining Charts 5.4.4Exporting Executable Reports 5.4.5Customizing Excel Reports 5.4.5.1 Adding Custom Columns to a Data Sheet 5.4.5.2 Creating a Custom Chart Page 5.4.5.3 Saving Customized Settings Interpreting Report Metrics 6.1 Summary Report Page Page Page Page 6.2 Space Reports 6.2.1 PD Space Reports 6.2.2 LD Space Reports 6.2.3 VV Space Reports Page Page 6.3 Performance Reports 6.3.1 Common Performance Metrics Page 6.3.2 VV Cache Performance Reports 6.3.3 Node Cache Performance Reports 6.3.4 CPU Performance Reports 6.3.5 Link Performance Reports 6.4 Adaptive Optimization Reports 7.1 Accessing the System Reporter Policies 7.2 Configuring Sampling Policies 7.2.1 Compacting Databases 7.2.2 Editing Sampling Policies Page 7.3Adding, Removing and Re-ConfiguringInServ Storage Systems 7.3.1Adding a Storage Server 7.3.2 Verifying Addition of a Storage Server 7.3.3 Removing a Storage Server 7.3.4 Re-Configuringa Storage Server Sampling 7.4 Configuring Rules for Email Alerts 7.4.1 Adding an Alert Rule 7.4.2Changing an Alert Rule 7.4.3Removing an Alert Rule 7.4.4Alert Rule Parameters 7.4.4.1 Data Table 7.4.4.2 Resolution 7.4.4.3 System 7.4.4.4 Metric Page Page 7.4.4.5 Direction 7.4.4.6 Limit Value 7.4.4.7 Limit Count 7.4.4.8 Condition 7.4.4.9 Condition Value 7.4.5 Example of an Alert Rule 7.5 Scheduling Reports 7.5.1 Adding a Scheduled Report 7.5.2 Changing a Scheduled Report 7.5.3 Removing a Scheduled Report 7.6 Configuring Adaptive Optimization 7.7 About File Permissions 7.8 Modifying the Apache HTTP Server Configuration Files Page Web Queries 8.1 About Web Queries 8.2 Data Format Version Report Page 8.3 About Reports and Options 8.4 Report Options 8.4.1 category 8.4.1.1 example: 8.4.2 compare 8.4.2.1 values: Page 8.4.2.2 example: 8.4.3 comparesel 8.4.3.1 values: 8.4.4 table 8.4.4.1 values: 8.4.4.2 example: 8.4.5 refresh 8.4.5.1 values: 8.4.5.2 example: 8.4.6 charttab 8.4.6.1 values: 8.4.7 charttype 8.4.7.1 values: 8.4.7.2 example: 8.4.8 graphx 8.4.8.1 value: 8.4.8.2 example: 8.4.9 graphy 8.4.9.1 value: 8.4.10 graphlegpos 8.4.10.1 value: 8.4.10.2 example: 8.4.11 tableformat 8.4.11.1 value: 8.4.12 alllabels 8.4.12.1 values: 8.4.12.2 example: 8.4.13 timeform 8.4.13.1 values: 8.4.13.2 example: 8.4.14 begintsecs 8.4.14.1 value: 8.4.15 endtsecs 8.4.15.1 value: 8.4.15.2 example: 8.4.16 groupby 8.4.16.1 values: Page 8.4.16.2 example: 8.4.17 orderby 8.4.17.1 values: Page Page Page 8.4.17.2 example: 8.4.18 histbegin 8.4.18.1 values: 8.4.18.2 example: 8.4.19 ldspaceunit 8.4.19.1 values: 8.4.20 pdspaceunit 8.4.20.1 values: 8.4.20.2 examples: 8.4.21 vvspaceunit 8.4.21.1 values: 8.4.21.2 examples: 8.4.22 selcageid 8.4.22.1 value: 8.4.22.2 examples: 8.4.23 selchunks 8.4.23.1 values: 8.4.23.2 example: 8.4.24 selcpg 8.4.24.1 value: 8.4.24.2 example: 8.4.25 selusrcpg 8.4.26 selsnpcpg 8.4.28 seldiskspeed 8.4.28.1 value: 8.4.28.2 example: 8.4.29 seldomain 8.4.29.1 value: 8.4.29.2 example: 8.4.30 selhost 8.4.30.1 value: 8.4.30.2 example: 8.4.31 selld 8.4.31.1 value: 8.4.31.2 example: 8.4.32 sellduse 8.4.32.1 values: 8.4.33 selnode 8.4.33.1 value: 8.4.33.2 example: 8.4.34 selnsp 8.4.34.1 value: 8.4.34.2 example: 8.4.35 selpdid 8.4.35.1 value: 8.4.35.2 example: 8.4.36 selpdstate 8.4.36.1 values: 8.4.36.2 example: 8.4.37 selporttype 8.4.37.1 values: 8.4.38 selraidtype 8.4.38.1 values: 8.4.38.2 example: 8.4.39 selsys 8.4.39.1 values: 8.4.39.2 example: 8.4.40 selvv 8.4.40.1 values: 8.4.40.2 example: 8.4.41 selvvtype 8.4.41.1 values: 8.4.42 selprovtype 8.4.42.1 values: 8.5 Report Types 8.6Summary Report 8.6.1 summary 8.6.1.1 example: 8.7 Space Reports 8.7.1 pd_space_time 8.7.3 ld_space_time 8.7.3.1 example: 8.7.4 ld_space_group 8.7.4.1 example: 8.7.5 vv_space_time 8.8 Performance Reports 8.8.1pd_perf_time 8.8.1.1 example: 8.8.2 pd_perf_group 8.8.2.1 example: 8.8.3 pd_svt_hist 8.8.3.1 example: 8.8.4 pd_svt_histvstime 8.8.4.1 example: 8.8.5 port_perf_time 8.8.5.1 example: 8.8.6 port_perf_group 8.8.7 port_svt_hist 8.8.7.1 example: 8.8.8 port_svt_histvstime 8.8.8.1 example: 8.8.9 ld_perf_time 8.8.10 ld_perf_group 8.8.10.1 example: 8.8.11 ld_svt_hist 8.8.11.1 example: 8.8.12 ld_svt_histvstime 8.8.13 vlun_perf_time 8.8.13.1 example: 8.8.14 vlun_perf_group 8.8.14.1 example: 8.8.15 vlun_svt_hist 8.8.16 vlun_svt_histvstime 8.8.16.1 example: 8.8.17 vv_cmp_time 8.8.17.1 example: 8.8.18 vv_cmp_group 8.8.19 cpu_perf_time 8.8.19.1 example: 8.8.20 cpu_perf_group 8.8.20.1 example: 8.9 Adaptive Optimization Reports 8.9.1 regiodensity 8.9.1.1 regiondensity example 8.9.2 regmoves 8.9.2.1 regmoves example 8.10 Options Available by Report Page Page Page Page 8.11 Objects Present Reports Page Page Page 8.11.1 objectpres= cageid 8.11.1.1 example: 8.11.1.2 output: 8.11.2 objectpres= cpg_name 8.11.2.1 example: 8.11.2.2 output: 8.11.3 objectpres= diskspeed 8.11.3.1 example: 8.11.3.2 output: 8.11.4objectpres= disktype 8.11.4.1 example: 8.11.4.2 output: 8.11.5 objectpres= domain_name 8.11.5.1 example: 8.11.5.2 output: 8.11.6objectpres= host_name 8.11.6.1 example: 8.11.7 objectpres= ld_name 8.11.7.1 example: 8.11.7.2 output: 8.11.8 objectpres=node 8.11.8.1 example: 8.11.8.2 output: 8.11.9 objectpres=pdid 8.11.9.1 example: 8.11.9.2 output: 8.11.10 objectpres=port 8.11.10.1 example: 8.11.10.2 output: 8.11.11 objectpres= system 8.11.11.1 example: 8.11.11.2 output: 8.11.12 objectpres= vv_name 8.11.12.1 example: 8.11.12.2 output: 8.11.13 objectpres= vv_name_nosnap 8.11.13.1 example: 8.11.13.2 output: 8.11.14 objecctpres= porttype 8.11.14.1 example: 8.11.14.2 output: 8.11.15 sample_times 8.11.15.1 example: 8.11.15.2 output: Page Page Using Adaptive Optimization 9.1 Overview Page 9.2 Selecting an InServ for Adaptive Optimization 9.3 Configuring Adaptive Optimization Page 9.3.1Tier Definition (CPG Name and GiB) Page Page 9.3.2 Schedule 9.3.3 Measurement Hours 9.3.4 Adaptive Optimization Mode 9.3.5 Adaptive Optimization Active 9.3.6 Adding an Adaptive Optimization Configuration 9.3.7 Changing an Adaptive Optimization Configuration 9.3.8 Removing an Adaptive Optimization Configuration 9.4 Adaptive Optimization Reports 9.4.1 Region IO Density Report Page Page 9.4.2 VV Tiers Report 9.4.3 Adaptive Optimization Space Moved Report 9.5 The showvvcpg CLI extension Page Page Database Schema 10.1 Using The Database Schema 10.2 Table Versions and Naming Conventions 10.3 Administrative Tables 10.3.1 The policy Table 10.3.2 The sampleinserv Table 10.3.3 The system Table 10.3.4 The alertconfig Table Page 10.3.5 The scheduled_report Table Page 10.3.6 The scheduled_report_log Table 10.3.7 The adprovconfig Table Page 10.3.8 The adprov_log Table 10.3.9 The ldrgmoves Table Page 10.3.10 The recentsample Table 10.4 The Sample Data and Inventory Tables 10.4.1 The pdspace Table Page Page 10.4.2 The pdspaceinv Table 10.4.3 The ldspace Table Page 10.4.4 The ldspaceinv Table 10.4.5 The vvspace Table Page Page 10.4.6 The vvspaceinv Table Page 10.4.7 The cpgspace Table Page 10.4.8 The cpgspaceinv Table 10.4.9 Common Performance Table Columns Page Page Page Page 10.4.9.1 Calculating Common Performance Metrics 10.4.9.2 Service Time Histogram Buckets 10.4.9.3 IO Size Histogram Buckets 10.4.10 The statpd Table Page 10.4.11 The statpdinv Table 10.4.12 The statld Table 10.4.13 The statldinv Table 10.4.14 The statport Table 10.4.15 The statportinv Table Page 10.4.16 The statvlun Table 10.4.17 The statvluninv Table 10.4.18 The statvvcmp Table Page 10.4.19 The statvvcmpinv Table 10.4.20 The statcpu Table Page 10.4.21 The statcpuinv Table 10.4.22 The statlink Table Page 10.4.23 The statlinkinv Table 10.4.24 The statldrg Table 10.4.25 The statldrg_timeinv Table 10.4.26 The perf_timeinv Table 10.4.27 The space_timeinv Table Page 11 Troubleshooting 11.1 Troubleshooting Overview 11.2 Troubleshooting the Sampling Components 11.2.1 Sampling Component Log Files 11.2.2 Installation Configuration 11.2.3 InServ Sampling Errors 11.2.3.1 Errors incurred by the inservsample process 11.2.3.2 Errors incurred by the CLI sampler process 11.2.4 Sampler Service/Daemon Errors 11.3 Troubleshooting Adaptive Optimization Components 11.4 Troubleshooting the Web Server Components 11.5 Troubleshooting the Excel Client 11.6 Extracting Data from the Database with sysbck Page 11.6.1 Examples of Using sysbck for Various Databases Page Page Page 11.7 Dumping the Entire Database 11.7.1 Dumping the Entire SQLite Database 11.7.2 Dumping the Entire MySQL Database Page Index IX.2 Index Page IX.4 Index Page IX.6 Index Revision History RH.1 RH.2 RH.3 RH.4 RH.5 RH.6 RH.7 RH.8