HP Storage Essentials Storage Resource Management Report Optimizer Software 6.
Legal and notice information © Copyright 2002-2008 Hewlett-Packard Development Company, L.P. Hewlett-Packard Company makes no warranty of any kind with regard to this material, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Hewlett-Packard shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of this material.
Contents About this guide . . . . . . . . . . . . . Contents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .v Intended audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Prerequisites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Related documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
iv
About this guide This guide provides the general background information and specific task instructions that will help you successfully create realistic reports in a complex HP Storage Essentials SRM environment.
Table 1 Additional Documentation Document Description Performing On-Report Analysis with Web Intelligence. Provides information about viewing, analyzing, and enhancing Web Intelligence reports interactively on the web. This guide includes information on filtering and sorting report data, adding calculations, and modifying the formatting and data content of reports (all without needing to launch a Web Intelligence report panel).
HP technical support Telephone numbers for worldwide technical support are listed on the HP support web site: http://www.hp.com/support/. Collect the following information before calling: • Technical support registration number (if applicable) • Product serial numbers • Product model names and numbers • Applicable error messages • Operating system type and revision level • Detailed, specific questions For continuous quality improvement, calls may be recorded or monitored.
viii About this guide
1 Creating Reports in a Complex Environment This chapter contains the following topics: • Introduction and Goals on page 1 • Selecting Objects for a Report on page 1 • How to Use Wild-card Searching with the Filters on page 13 • Selecting Context on page 14 • Example Use Cases on page 21 Introduction and Goals HP Storage Essentials SRM software can manage very complex enterprise SAN environments encompassing thousands of devices.
Independent Classes - Asset, Chargeback, Discovery details, and Tape Library are independent classes. They do not interact with any other class, and the queries involving these classes cannot be combined with other classes. For example, you cannot combine objects from the Asset class and the Host class. If you are interested in generating a report that contains independent classes, a different query must be added to the same report.
Table 1-1: Class Categories Category What it means Example Capacity Statistics - Drill Collectors periodically capture every element statistic. These stats, collected for every interval, are represented in the “Drill” statistics class. Use this class in the reports when you want to drill up or drill down. Host > Host Volumes > Host Volume Capacity Statistics - Drill Use this class if you are interested in the drill functionality of the product. Repeating objects - Objects are repeated across classes.
• Discovery Details Class • Tape Library Class • NAS Class The following table summarizes class compatibilities. Compatible classes are marked with an X, and all unmarked combinations are incompatible.
Avoiding #MULTIVALUE Errors If there are multiple values for an object in a report, the #MULTIVALUE error occurs when the report is run. To avoid this situation, design reports so that each object in the report represents a unique value. In general, for each main class, a report will require a unique object. If you have created a report containing all required objects, and a #MULTIVALUE error occurs, then include any required objects from the appropriate sub-class(es).
Table 1-3: Required Objects Class Name Required Object Name Exchange Application Capacity - Historical Application Name, Organization Name, Host Name, Collection Time, Statistics Type, Storage Group Name Exchange Application Capacity - Latest Application Name, Organization Name, Host Name, Storage Group Name Virtual Application Capacity - Historical Application Name, Organization Name, Host Name, Collection Time, Statistics Type, Virtual Path Virtual Application Capacity - Latest Application Name,
Table 1-4: Resolving #MULTIVALUE Errors Use Case Create a report to show total storage capacity. Select all of the following: Cause of #MULTIVALUE Error Resolution There can be multiple storage systems with the same vendor name. Select a unique object, such as Storage System name. There can be multiple logical volumes on a given host. Select the Logical Volume Name object from the Host Volumes class.
• Use the “Class name” class for a report containing only objects from one class or sub-classes, or when using Generic and Managed contexts • Use “Class name for Dependency” when combining objects of different classes. Use “Class name for Dependency” classes only to find objects used in connectivity or dependency with objects in other classes. Examples include: host-dependent storage systems and host-dependent switches.
Table 1-5: When to Use the “XYZ for Dependency” Classes Classes • Storage System Fiber Channel Ports • Storage System Fiber Channel Ports for Dependency Usage Guidelines • Use the Storage System Fiber Channel Ports class to find all of the fiber channel ports for a given storage system, Use this class only with the Storage System class and/or its sub-classes, or in combination with Switch class and its sub-classes.
Table 1-6: Using the “XYZ for Dependency” Classes when Creating Reports To Create This Report Show switch-dependent storage systems and details Select All of These Objects • Switch > Switch Name • Switch > Switch Ports > Switch Port Name • Storage System > Storage System Name • Storage System > Vendor • Storage System > Storage System Fiber Channel Ports > Storage Port Name When to Use the “XYZ - Latest,” “XYZ - Historical,” and “XYZ - Drill” Classes SRM Report Optimizer provides the most recently calcul
Table 1-8: Using the “XYZ - Latest,” “XYZ - Historical,” and “XYZ - Drill” Classes Classes Name • Host > Host Volumes > Host Volume Capacity Statistics - Latest • Host > Host Volumes > Host Volume Capacity Statistics - Historical • Host > Host Volumes > Host Volume Capacity Statistics - Drill Under what circumstances should each class be used • Use the Host Volume Capacity Statistics - Latest class when you want the latest host volume capacity information.
Events Classes The following table describes the Events classes: Table 1-9: Events Classes Events Classes Examples • The Events class provides all events, including: application, host, storage system, switch, fabric, etc. Events is an independent class and cannot be used in combination with any other classes. • The Application Events class provides event information for applications only. • The Host Events class provides event information for hosts only.
Assets Classes The following table describes the Assets classes: Table 1-10: Assets Classes Assets Classes • The Asset class gives information about all the assets in your environment. The Assets class is an independent class and cannot be used in combination with any other classes. Examples • The Application Assets class gives asset information for applications only. • The Host Assets class gives asset information for hosts only.
The following table provides examples of the “Different from Pattern” option: Table 1-12: The Different from Pattern Option “Different from Pattern” typed in the text field %test% Possible Output • Host.usa.com • Te23st123 Comments The output must not contain the word “test.” • Host_123 • mycomp.usa.com A%1% • A.test.usa.com • sed1 • 74188 The output must not start with “A” and have “1” as one of the characters.
Figure 1 Query Contexts Once the report is designed, you can disable context prompting, so that the pre-selected context will be used automatically whenever the report is run or scheduled.
Figure 2 Reset contexts on refresh All Report Pack reports default to a particular context, so you will not be prompted to select a context when running or scheduling a Report Pack report. Context Types The following are the types of contexts that are used: • Managed elements: Elements that are discovered through the management server. • Generic elements: Elements that are not discovered through the management server, but are available when the fabric is discovered.
NOTE: Not all contexts are visible to the end user. • Managed Elements: Application Host Switch Storage Connectivity - Use this context if you want to find out the connectivity between (Applications and Hosts) OR (Applications and Switches) OR (Applications and Storage systems) OR (Hosts and Switches) OR (Hosts and Storage systems) OR (Switches and Storage systems) OR (Applications, Hosts, Switches and Storage systems).
• Managed & Generic Elements: Switch Storage Connectivity - Use this context if you want to find out the connectivity between (Storage Systems and Switches) OR vice versa • Managed & Generic Elements: Fabric Host Application - Use this context if you want to find out the Host (along with Application) information related to a Fabric • Managed & Generic Elements: Fabric Host Backup - Use this context if you want to find out the Host (along with Backup) information related to a Fabric.
Table 1-13: Context Summary Managed Elements: Backup Host Switch Storage Connectivity X X X X Managed Elements: File Server Host Switch Storage connectivity X X X X X X X X X X X X X X X X X X X Tape Libraries X X X Fabrics X X X File Servers Backup NAS X X X Managed & Generic elements: Storage Host File Server connectivity X X X Managed & Generic elements: Storage Host Backup connectivity X X X Managed & Generic elements: Storage Host Application Connectivity Switche
Table 1-13: Context Summary X X X X X X X Managed & Generic elements: Switch Host Backup connectivity X X Managed & Generic elements: Switch Host File Server connectivity X X X X X X X Managed & Generic elements: Fabric Storage Managed & Generic elements: Fabric Switch Managed & Generic elements: Tape Library 20 Creating Reports in a Complex Environment Tape Libraries X X X X X X X Managed & Generic elements: Fabric Host File Server X X X X Managed & Generic elements: Fabric Host
Example Use Cases This section provides example use cases to illustrate the process of creating new reports. Each use case describes the user goal and the steps to create the desired report. This section focuses on the steps related to selecting the appropriate classes, objects, contexts, and functions to create specific reports.
• of the mounted volumes, how much is used and free To create this report: 1.
4. Select the following objects from the Report Connector universe, and drag them onto the Results Objects/Query Filters panel for the second query.
Figure 3 Allocated, Mounted, and Used Storage Report Use Case 2: Creating a High-Level List of Managed Hosts User Goal - Create a report showing a high-level list of all managed hosts. To create this report: 1.
Class > Subclass(es) Object/Filter Host Total Physical Memory in MB Host > Host CIM Extension Version Build Number Host Managed Hosts filter Host Non-Cluster Host filter 2. Click Run Query to run the report. 3.
The following figure shows an example of a Host Summary Report: Figure 4 Host Summary Report NOTE: The Host Summary Report contains additional details not visible in this figure. Use Case 3: Reporting the Application-Specific Utilization for a Managed Application User Goal - Create a report showing the application specific utilization for a managed application. For example, this report will show table space utilization for a database, or mail store utilization for Microsoft Exchange.
Class > Subclass(es) Object/Filter Application > DB Application Physical Capacity - Latest Free in GB Application Select Application with Host Name filter 2. To find information about the Exchange applications: a. Click Add a combined query. b. Use the default operator “UNION” to combine these two queries. c. Remove all the default objects except Host Name, IP Address, and Application with Host Name. d.
d. Select the following objects/filters from the SRM Report Optimizer universe, and drag them onto the Results Objects/Query Filters panel.
4. Run the report. The following contexts will be offered when you run the report: • Managed & Generic Elements: Fabric Host Application • Managed & Generic Elements: Storage Host Application Connectivity • Managed & Generic Elements: Switch Host Application Connectivity • Managed Elements: Application Host NAS Connectivity • Managed Elements: Application Host Switch Storage Connectivity 5. Select Managed Elements: Application Host Switch Storage Connectivity. 6.
Variable Name Formula V_Used =Sum([Used in GB]) V_Free =Sum([Free in GB]) % Used =If ([V_Total]=0;0;[V_Used]/[V_Total]) % Free =If ([V_Total]=0;0;[V_Free]/[V_Total]) a. Replace content of Total in GB with V_Total. b. Replace content of Used in GB with V_Used. c. Replace content of Free in GB with V_Free. d. Drag % Used and % Free to the end column of the table. 8. Format the report: a. Right-click these two columns: % Used and % Free b.
Figure 5 Application Utilization Summary Report Use Case 4: Reporting a Specified Number of Oldest Files for Each Volume in Each File Server User Goal - Create a report showing a specified number of the oldest files for each volume in each file server. To create this report: 1.
Class > Subclass(es) Object/Filter File Server > Volumes Summary > Top N Aged Files File Name File Server > Volumes Summary > Top N Aged Files File Modified File Server > Volumes Summary > Top N Aged Files File Created File Server > Volumes Summary > Top N Aged Files File Owner Name File Server > Volumes Summary > Top N Aged Files File Accessed File Server > Volumes Summary > Top N Aged Files File Size in GB 2. Add database ranking to the query by clicking Add a database ranking: a.
f. Click the arrow button at the right end of the filter box. g. Drag File Name to the “drop a dimension here” field after the For Each label. h. Drag ‘File Server Name’ to “drop a dimension” here” field after For Each label. i. Drag ‘Volume Name’ to “drop a dimension” here” field after For Each label. 3.
5. Drag File Server Name to the top of the table to create a section. 6. Run the report.
NOTE: This report contains additional details that are not visible in the figure. Use Case 5: Reporting NAS Information and Details for the Client host and Application User Goal - Create a report showing NAS information and details for the client host and application. To create this report: 1.
6. To find information on the applications, select the following objects/filters from the SRM Report Optimizer universe, and drag them onto the Results Objects/Query Filters panel: Class > Subclass(es) Object/Filter Application Application Name Application Description NAS Filer Name NAS > NAS Dependent NAS Hosts NAS Host NAS NAS Hosts filter 7. Drag Filer Name from the report to the top of the table to create a section. 8. Run the report.
Use Case 6: Reporting Storage Tier Information, Hosts, and Storage Volumes User Goal - Create a report showing the storage tier information, hosts, and storage volumes for each storage pool. To create this report: 1.
Class > Subclass(es) Object/Filter Host > HBA for Dependency > HBA Ports for Dependency Port Name Host > HBA for Dependency > HBA Ports for Dependency WWN Storage System > Storage Tier Information for Chargeback Cost per GB Host Managed Hosts filter Storage System Managed Storage system filter 4. Run the report. 5. Create sections for Storage System Name and Storage Pool Name: a.
d. Rename Cost per GB to Cost. 8. Run the report.
Figure 8 Array-based Chargeback Report NOTE: This report contains additional details that are not visible in the figure. Use Case 7: Reporting Media Utilization Trends over a Specified Period User Goal - Create a report showing media utilization trends over a specified time period. To create this report: 1.
Class > Subclass(es) Object/Filter Backup > Resource Summary Statistics Historical Total Available Media Backup > Resource Summary Statistics Historical Total Allocated Media Backup > Resource Summary Statistics Historical Total Frozen Media Backup > Resource Summary Statistics Historical Total Suspended Media Backup > Backup Manager Details Select Backup Manager filter Backup > Media Server Details Select Media Server Name filter Backup > Resource Summary Statistics Historical Schedule Time
c. Drag Total Allocated, Total Available, Total Frozen, and Total Suspended to “Place measure objects here.” d. Uncheck the box “3D Look” under Properties > Display. 5. Run the report.
Figure 9 Media Trend - Media Summary Report Use Case 8: Reporting all Managed Hosts without Cluster Hosts and Cluster Member Hosts User Goal - Create a report showing the high-level list of all managed hosts without cluster hosts and cluster member hosts. To create this report, follow the steps outlined below. 1.
Class > Subclass(es) Object/Filter Host OS Host OS Version Host Managed Hosts filter 2. Run the report. 3. Filter out the cluster host and cluster member hosts as follows: a. Drag the Non-Cluster Host filter from the Host class onto the query filter panel. b. Click Add a Sub-query. The sub-query dialog box displays: c. Drag Host Name to the first “Drop an object here” field in the sub-query. d. Select Not Equal to from the drop-down list in the sub-query: e.
Figure 10 Hosts Report Without Clusters and Cluster Nodes Use Case 9: Reporting Host capacity with Drill-down to Host Volumes User Goal - Create a report showing host capacity for each host, and providing the ability to drill-do.wn to each host volume. To create this report: 1.
Class > Subclass(es) Object/Filter Host > Host Volumes > Host Volume Capacity Statistics Historical Total in GB Host > Host Volumes > Host Volume Capacity Statistics Historical Used in GB Host > Host Volumes > Host Volume Capacity Statistics Historical Free in GB Host Managed Hosts filter Host > Host Volumes > Host Volume Capacity Statistics Historical Latest Collection time filter 2.
6. Create variables: Variable Name Formula Used space in GB =Sum([Used in GB]) Free space in GB =Sum([Free in GB]) 7. Run the report. 8. Create a bar chart: a. Select Vertical Grouped bar chart from the Templates tab. b. Drag Free space in GB and Used space in GB to “Drop measure objects here” in the graph. c. Drag Host Name to “drop Dimension objects here” in the graph. d. Enter “Host capacity” in Title > Text under the Properties page in Edit Report. e.
Figure 11 Bar chart and properties page 9. Run the report.
Figure 12 Host Capacity Before Drill-down to the Host Logical Volume 1. To drill down to the details for a host volume, click the Drill in “Edit Report.” 2. Click one of the host names to show the host logical volumes for the selected host, along with the total, used, and free for each volume.
1. Figure 13 Host Capacity with drill-down to host logical volumes Use Case 10: Reporting Top N EVA Performance. User Goal - Create a report showing performance statistics for the top HP EVA arrays. To create this report: 1.
Class > Subclass(es) Object/Filter Storage System > Performance Statistics > EVA > EVA Storage System Statistics - Historical Duration (Sec) Storage System > Performance Statistics > EVA > EVA Storage System Statistics - Historical Total Data Rate (bytes/sec) Storage System > Performance Statistics > EVA > EVA Storage System Statistics - Historical Total I/O rate (req/sec) Storage System Storage System Name Storage System > Performance Statistics > EVA > EVA Storage System Statistics - Historical
4. Create the necessary variables using the following formulas: Variable Name Formula UserResponse =ToNumber(UserResponse("Top x Storage System Name (Enter x)")) Rank_dataRate Rank([Total Data Rate (Bytes/Sec)];([Storage System Name];[Statistics Type]);([Statistics Type])) Rank_Condition If([Rank_dataRate]<=[UserResponse] ForAll([Storage System Name]) ;1;0) 5. Create a ranking condition in the report: a. Click Show/Hide Filter pane. b. Drag the Rank_Condition variable to the Report Filters panel.
6. Run the report.
54 Creating Reports in a Complex Environment