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

HP 3PAR System Reporter E-Media Kit, System Reporter Media Kit 7.5.2 Changing a Scheduled Report

1 378

Download 378 pages, 2.5 Mb

3PAR System Reporter User’s Guide

System Reporter 2.8

6Specify the report name.

7Specify the report schedule. Hold the CTRL key to pick multiple dates and times. The minimum possible granularity of a scheduled report is 1 hr.

8Specify the report URL parameters (you can copy these from the address bar of the report that define the report). Do not include the http:// portion of the URL. The maximum size of a URL should not exceed 4000 characters.

9Choose whether or not the report should be currently active or not (true/false). This option allows you to turn the report generation on and off as needed.

10Specify the number of days to retain a scheduled report. System Reporter will automatically delete reports that are older then the specified number of days. The default is 7 days.

11When done, click Submit Query. An alert window appears confirming that the report has been scheduled.

12Click OK to return to the Sampling Policies window.

7.5.2 Changing a Scheduled Report

To change a scheduled report:

1Point your browser at the Web server where Apache HTTP Server and the 3PAR System Reporter Web server scripts are installed.

The 3PAR System Reporter main window appears.

2Click on Policy Settings in the Extras Menu area. The System Reporter Policies window appears.

3Choose the Scheduled Reports tab.

The Scheduled Reports window appears.

4Click Change next to the scheduled report that you want to change. The Change Scheduled Report window appears.

5Change the appropriate settings.

6When done, click Submit Query. An alert window appears confirming that the scheduled report has been changed.

7Click OK to return to the Sampling Policies window.

7.20	Scheduling Reports

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