Creating a Custom Chart | HP System Reporter E-Media Kit manual

3PAR System Reporter User’s Guide

System Reporter 2.8

The Dly PDSpace (1) sheet is created to hold the data represented in the chart at the bottom of the PD Space reporting tool sheet.

2On the Dly PDSpace (1) sheet, scroll to the first empty cell to the right of Data table. In cell N52, click and type a new header for Non-failed spare.

3Below the new header, in cell N53, click and then add a formula to sum the columns that

have values for spares that are not failed:

=H53+J53+K53

Press ENTER after typing in the formula. A calculated value should appear in cell N53.

4Click cell N53 and drag the cell selection down so that the formula is copied to all rows of the table.

To drag the cell selection down, you must position your pointer over the lower right corner of the cell and then click and drag. Calculated values should appear in all cells of column N.

5In cell O52,click and type a new header for Percent spare used.

6Below the new header, in cell O53, add a formula to calculate the percentage of non-failed

spare space that is used:

=IF(N53>0,H53/N53*100,0)

Press ENTER after typing in the formula. A calculated value should appear in cell O53.

7Click cell O53 and drag the cell selection down so that the formula is copied to all rows of the table.

To drag the cell selection down, you must position your pointer over the lower right corner of the cell and then click and drag. Calculated values should appear in all cells of column O.

On the PDSpace Time Data sheet, the newly added columns are appropriately resized and populated with values that reflect the most recent query results.

5.4.5.2 Creating a Custom Chart

After adding custom columns to a data sheet, you can use those columns to create custom charts.

The following instructions illustrate how to create a custom chart from one of the custom Dly PDSpace (1) sheet columns you added in Adding Custom Columns to a Data Sheet on

page 5.57.

5.58

Working with Excel Charts

Image 150

HP System Reporter E-Media Kit, System Reporter Media Kit Creating a Custom Chart, =H53+J53+K53, =IFN530,H53/N53*100,0

Contents

3PAR System Reporter 2.8 User’s Guide Revision Notice Oractcl Copyright and License Page Page Page Preamble Page Page No Warranty Table of Contents Installation, Configuration, Update, and Removal Xii Xiii Removing the System Reporter Components Xiv Creating Custom Reports Working with Excel Charts Xvi Interpreting Report Metrics Xvii Web Queries Xviii Xix Performance Reports Using Adaptive Optimization Database Schema Xxi Troubleshooting Xxii Xxiii Xxiv Audience User Interfaces Related Documentation For information about… Read the… Organization Typographical Conventions AdvisoriesTypeface Meaning Example ABCDabcd Overview and Features About 3PAR System Reporter Configuring System Reporter Policy Settings Choosing a Method for Accessing Reports Creating Customized Reports Report Name Description Report Metrics Cross Reference Node Cache Performance Formatting Reports for Presentation Accessing Report Data using Web Queries Customizing the Reporting FormatGenerating Email Alerts Using the Database Schema to Build Custom Reports Analyzing and Optimizing Storage Utilization Installation, Configuration, Update, and Removal Before You Begin System Reporter CD Contents Apache2.2.14 Installer.exeSetup.exe Win32-x86-openssl System Requirements System Component Minimum Requirement InServ Storage Server System Requirements Using the System Reporter Sizing Spreadsheet System Reporter Sizing Spreadsheet Using the System Reporter Sizing Spreadsheet System Reporter Components InServ Storage Server and User Interface Components System Reporter Components Installing the System Reporter Components Installing the System Reporter Components Section Installing the Web Server Installing the Database Server Choosing the Appropriate DatabaseSQLite MySQL Oracle Installing and Setting Up the MySQL Database Optional Comment SQLite MySQL Oracle Installing MySQL Server Configuring the MySQL Database Select Multifunctional Database then click Next Setting the maxallowedpacket parameter Maxallowedpacket=32M Creating MySQL Users and Schema Mysql -u root -p Setting Up the Oracle Database Optional Start the Oracle Database Configuration AssistantCreating an Oracle database Creating the Oracle Users for System Reporter Creating the Oracle Net Service Installing or Upgrading the System Reporter Tools Installing or Upgrading System Reporter Tools on Windows3PAR System Reporter Installer window opens Installing or Upgrading the System Reporter Tools Installing or Upgrading the System Reporter Tools Installing or Upgrading the System Reporter Tools Installing System Reporter Tools on Linux Rpm --install sampleloop-2.8-1.i386.rpm Etc/init.d/sampleloop start Adding InServ Systems 3PAR System Reporter window appears Setting File Permissions Optional Verifying InstallationClick Submit Query Installing the Excel Client Optional About Apache Http Server Authorization and Access Control Directory cgi-bin/3par-rpts AuthType Basic Removing the System Reporter Components Removing the System Reporter Tools on Windows Removing the System Reporter Tools on Linux Removing the MySQL Database Optional Drop user cliuser drop user webuser Accessing the Main System Reporter Interface Getting Started Connection Dialog Box System Reporter Main Menu Window System Reporter Main Window Getting Help Using the Object Selection Controls Simple Selection ListFiltered Multi-Selection Control Accessing the Optional Excel Client Starting the System Reporter Excel Client Setting the Security Level for Excel Setting the Security for Excel Security Warning for Enabling Macros in Excell Setting the Security Level Setting the Security Level for Excel Macro Security Alert for Excel Click Trust Center Click Trust Center Settings Trust Center Screen Connecting to the Web Server from the Excel Client Connection Parameters dialog box appears Figure Changing the Excel Client Server and Resetting the Workbook Accessing the Excel Client Query Log Resetting the WorkbookChanging the Web Server Deleting Menu Sheets Deleting Data SheetsDeleting Excel Sheets Deleting the Query Log Saving and Exiting the Excel Client 10.Security Alerts Multiple Issues Accessing and Creating Reports Accessing Quick Reports Quick Reports Window Accessing Scheduled Reports Scheduled Reports Window Creating Custom Reports Building the Report Menu Custom Reports Window Sample Resolution Report Common Performance Metrics on page 6.11 for Select Systems Option Purpose Select Domains Generating the Report Report Menu for Daily Vlun Performance Creating Custom Reports Creating Custom Reports Query Results Controls Available by Report Report Selection Report Time SelectionObject Selection 3PAR System Reporter User’s Guide Report Selection Format Selection Standard Report Types Report Type Purpose Versus TimeAt Time Report Type Purpose Histogram Histogram AtTime Versus Time Report Example Versus Time with Compare=System Report Example Group By SystemHost At Time Report Example Histogram Versus Time Report Example Select Summary Columns 10.Histogram At Time Report Example Compare Select PeakGroup By Pdid System Reporter Order By Order by the CPG that the LD belongs to Low Bucket High BucketSum End Buckets Begin/At Time Time SelectionReload After mins End Time Count Object Selection Select PDIDsInclude Chunklets Select Cage IDs Select Disk Types Select Disk Speed Include PDs in States Select Usr CPGs Select Snp CPGs Select CPGs Select LDs Select RAID Types Select LD Usage Select VVs Select Prov Types CTRL+CLICK Select VV Types Select Ports nsp Select Port Types Select Hosts Select Nodes Select To Nodes Format Selection Web interface only Select QueuesReport Information Chart Types 11.Example of a Table Stacked Bars Stacked Vert Bars Stacked Area Lines Bars Vert Bars Chart X Pixels Chart Y PixelsTime Labels Time Format Select Space Unit Working with Excel Charts Choosing a Chart TypeChoose Change Chart Type Refreshing Charts 18.Change Chart Type Menu for the Excel Client External Data Range Properties dialog box appears 19.Data Range Properties Shortcut Menu Retaining Charts 20.External Data Range Properties Dialog Box Exporting Executable Reports Adding Custom Columns to a Data Sheet Customizing Excel Reports Creating a Custom Chart =H53+J53+K53=IFN530,H53/N53*100,0 Working with Excel Charts Saving Customized Settings Chart Interpreting Report Metrics Summary Report Metric Description Summary Report Metrics 3PAR System Reporter User’s Guide Metric Description Space Reports PD Space Reports LD Space Reports Usage Type Description Spare, Unused, FailedTotals VV Space Reports VV Space Report Metrics 3PAR System Reporter User’s Guide Performance Reports Common Performance Metrics 3PAR System Reporter User’s Guide VV Cache Performance Reports Node Cache Performance Reports CPU Performance Reports Adaptive Optimization Reports Link Performance Reports Configuring the System Reporter Policy Settings Accessing the System Reporter Policies CLI password files Configuring Sampling PoliciesPolicy Default Full path to directory containing InForm Etc/clipwdir on Linux Compacting Databases See Compacting Databases on Editing Sampling Policies Connection Dialog Box Adding, Removing and Re-Configuring InServ Storage Systems Removing a Storage Server Adding a Storage ServerVerifying Addition of a Storage Server Click Remove InServ Re-Configuring a Storage Server Sampling 3PAR System Reporter Policies window appears Configuring Rules for Email AlertsAdding an Alert Rule Click Add Alert Changing an Alert Rule Removing an Alert Rule Click Remove Alert Alert Rule ParametersData Table Data Table Description Resolution Resolution Description SystemMetric Metrics Description Data Tables Averaged over the sample Direction Limit Value Condition Example of an Alert RuleLimit Count Condition Value Scheduling Reports Scheduledreports/report directory/report name/YYYYMMDDHH Adding a Scheduled Report Choose the Scheduled Reports tabClick Add Scheduled Report Changing a Scheduled Report Removing a Scheduled Report Configuring Adaptive Optimization About File Permissions Modifying the Apache Http Server Configuration Files Modifying the Apache Http Server Configuration Files Web Queries About Web Queries Data Format Version Report System Reporter Version Report Category About Reports and OptionsReport Options Option=value Daily CompareExample Hourly Values ProvType HostVVType LDUsage Comparesel Totalspace InterruptsCtxtsws Rawspace Statpd PdspaceVvspace Statld Refresh CharttabChart Both Stackedvbars CharttypeStackedbars Stackedarea Graphx GraphyValue Graphlegpos TableformatBottom Right Alllabels Excel Timeform Begintsecs Endtsecs Tsecs Groupby PortNode Groupby=System Orderby Order results by Virtual Volume VV Type Bandwidth Service TimeIOPs IO Size Intr TotalAccessesIdle Ctxt Histbegin Ldspaceunit MiB 220 bytes PdspaceunitExamples GB 109 bytes Vvspaceunit Chunklets Selcageid All cage IDs Selchunks Nrmavaildrty Selchunkls=NRMAVAILCLEAN Selchunkls=NRMAVAILCLEAN&selchunks=SPRAVAILCLEAN Selsnpcpg SelcpgSelusrcpg Seldisktype Seldiskspeed All Disk TypesAll Disk Speeds Seldomain ALL DomainsDomainname ALL Hosts SelhostDomain2 Hostname All LDs SelldSellduse Ldname Selnode Log Selnsp All NodesAll Ports Selpdid ALL PDIDs All PD States SelpdstateSelporttype Valid Selraidtype Selraidtype=1&selraidtype=5 SelsysSelraidtype= All Systems Selvv Selvvtype Selprovtype Report Types Summary PdspacetimePdspacegroup Ldspacetime Ldspacegroup Vvspacetime VvspacegroupPdperftime Pdperfgroup Pdsvthist Pdsvthistvstime PortperftimePortperfgroup Ldperftime PortsvthistPortsvthistvstime Compare=System Ldperfgroup LdsvthistLdsvthistvstime Vlunperftime VlunperfgroupVlunsvthist Vlunsvthistvstime VvcmptimeVvcmpgroup Cpuperftime Cpuperfgroup Vvtier RegiodensityRegmoves Regiondensity example Options Available by Report Vvtier exampleReport Option M M Report Option Histsvtpd M M M M M M Objects Present Reports Http//localhost/cgi-bin/3par-rpts Using tableformat=excel Without using tableformat=excel Objectspresent&objectpres= ldname on Report Table values Objectpres= cageid Sampletimes on Objectpres= cpgname OutputObjectspresent&objectpres=cageid Objectpres= diskspeed Objectspresent&objectpres=cpgname Objectpres= disktype Objectspresent&objectpres=diskspeedObjectspresent&objectpres=disktype Objectpres= domainname Objectpres= hostnameObjectspresent&objectpres=domainname Objectpres= ldname Objectspresent&objectpres=hostname Objectpres=node Objectspresent&objectpres=ldname Objectpres=pdid Objectspresent&objectpres=node Objectpres=port Objectspresent&objectpres=pdid Objectpres= system Objectspresent&objectpres=port Objectspresent&objectpres=system using Objectpres= vvnameObjectspresent&objectpres=vvname Objectpres= vvnamenosnap Objectspresent&objectpres=vvnamenosnap Objecctpres= porttype Objectspresent&objectpres=porttype Sampletimes Time string with format yyyy-mm-dd hhmmss Objects Present Reports Objects Present Reports Using Adaptive Optimization Overview Overview Selecting an InServ for Adaptive Optimization Configuring Adaptive Optimization Adaptive Optimization Configuration Main Window Tier Definition CPG Name and GiB Configuring Adaptive Optimization Configuring Adaptive Optimization Schedule Measurement Hours Add Adaptive Optimization Configuration window appears Adaptive Optimization ModeAdding an Adaptive Optimization Configuration Adaptive Optimization Active Changing an Adaptive Optimization Configuration Change Adaptive Optimization Configuration window appears Removing an Adaptive Optimization Configuration Region IO Density Report Region IO Density with Adaptive Optimization Region IO Density without Adaptive Optimization VV Tiers Report Adaptive Optimization Space Moved Report Space Moved Report Showvvcpg CLI extension Cli% source showvvcpg.tcl CPG Showvvcpg CLI extension Using The Database Schema 10.1 10.2 Administrative TablesTable Versions and Naming Conventions Policy Table 10.3 Sampleinserv Table 10.4 System Table Alertconfig Table 10.5 10.6 Datatable value 10.7 Scheduledreport Table 10.8 Adprovconfig Table 10.9Scheduledreportlog Table 10.10 10.11 Adprovlog Table 10.12 Ldrgmoves Table 10.13 Sample Data and Inventory Tables 10.14Recentsample Table 10.15 Pdspace Table 10.16 10.17 10.18 Pdspaceinv Table 10.19 Ldspace Table 10.20 10.21 Ldspaceinv Table 10.22 Vvspace Table 10.23 10.24 10.25 Vvspaceinv Table 10.26 10.27 Cpgspace Table 10.28 10.29 Cpgspaceinv Table 10.30 Common Performance Table Columns 10.31 10.32 10.33 10.34 10.35 Calculating Common Performance MetricsMetric SQL Expression Service Time Histogram Buckets 10.36IO Size Histogram Buckets 10.37 Statpd Table 10.38 10.39 Statpdinv Table 10.40 Statld Table 10.41 Statldinv Table 10.42 Statport Table 10.43 Statportinv Table 10.44 10.45 Statvlun Table 10.46 Statvluninv Table 10.47 Statvvcmp Table 10.48 10.49 Statvvcmpinv TableSysuid 10.50 Statcpu Table 10.51 Null CPU 10.52 Statcpuinv TableStatlink Table 10.53 10.54 Statlinkinv Table 10.55 Statldrg Table 10.56 Statldrgtimeinv Table 10.57 Perftimeinv TableSpacetimeinv Table 10.58 Troubleshooting Overview 11.1 Troubleshooting the Sampling Components 11.2Sampling Component Log Files Installation Configuration InServ Sampling Errors11.3 Errors incurred by the inservsample process Troubleshooting Adaptive Optimization ComponentsSampler Service/Daemon Errors Errors incurred by the CLI sampler process Troubleshooting the Web Server Components Troubleshooting the Excel Client11.5 Extracting Data from the Database with sysbck 11.6 11.7 Examples of Using sysbck for Various Databases 11.8 11.9 From MySQL to Oracle 11.10 11.11 Dumping the Entire Database 11.12Dumping the Entire SQLite Database 11.13 Dumping the Entire MySQL Database 11.14 Index IX.1 IX.2 IX.3 IX.4 IX.5 IX.6 RH.1 Release level Revision summary Configuration, Update, and Removal RH.2 RH.3 RH.4 RH.5 RH.6 RH.7 RH.8