HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Contexts Guide (October 2008)

Creating Reports in a Complex Environment30
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. Select Format Number, and follow the Number Format dialog box instructions to set these
two columns to percentage format.
c. Drag Application with Host Name to the top of the table to create the section.
9. Create totals for each application:
a. Highlight the Total in GB column and select Sum from the drop-down list of the Insert Sum
button.
b. Highlight the Used in GB column and select Sum from the drop-down list of the Insert Sum
button.
c. Highlight the Free in GB column and select Sum from the drop-down list of the Insert Sum
button.
d. Select the cell under %Used and enter:
"=If(Sum([V_Total])=0;0;Sum([V_Used])/Sum([V_Total]))”
e. Select the cell under % Free and enter:
"=If(Sum([V_Total])=0;0;Sum([V_Free])/Sum([V_Total]))”
Right-click these two cells and select Format Number, and then follow the Number Format
dialog box instruction to set these two cells to percentage format.
10. Run the report.
The following figure shows an example of an Application Utilization Summary Report:
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])
Variable Name Formula