Creating a table report

Ops Center Analyzer User Guide
Version
11.0.x
Audience
anonymous
Part Number
MK-99ANA002-06

Create custom reports in table format to display configuration and capacity data.

This example shows how to create a table report by using the report template. You will create a table report for monitoring the capacity consumption of the monitored storage systems in your data center.

  • Only a system account user can create public reports that are accessible by all users. Public reports can only be edited or deleted by a system account user.
  • Users with admin or modify permissions can only create reports for private access. Private reports can be edited or deleted by the users who create them.
  1. From the Dashboard tab, click Dashboard Settings.
  2. In the Dashboard Settings window, click Create Report.
  3. In the Create Report window, either enter a query or select a report template for creating reports.
  4. Browse through the report templates listed in the Copy From list. Hover over the report names in the list to view details such as report name, description, size, query, and target time period to help you select an appropriate template.
  5. From Copy From list, select [Table]Capacity by Storage System.
    The report attributes such as name, description, type, size, query statement, and time period of analysis are autofilled with predefined values from the selected template. The query statement associated with the report template is autofilled in the Query text box. Edit the predefined values to customize your report.


    The Create Report window includes all the predefined report paremeter values so that you can edit them to create a custom report.

    The sample query for creating a table report for monitoring capacity by storage system is as follows: 
    raidStorage [=modelName rx .*] [=serialNumber rx .*]  [=ThinTotal rx .*] {inputCounters=raidPool[=poolType rx Provisioning].totalCapacityInGB, resourceRollupOp=SUM,outputUnit=GB}  [=ThinUsed rx .*] {inputCounters=raidPool[=poolType rx Provisioning].usedCapacityInGB, resourceRollupOp=SUM,outputUnit=GB}  [=ThinFree rx .*] {inputCounters=raidPool[=poolType rx Provisioning].availableCapacityInGB, resourceRollupOp=SUM,outputUnit=GB}  [=SubscribedTotal rx .*] {inputCounters=raidPool[=poolType rx Provisioning].subscribedCapacity, resourceRollupOp=SUM,outputUnit=GB}  [=fmcCapacitySaving rx .*] {inputCounters=raidPool[=poolType rx Provisioning].fmcPoolCapacitySaving, resourceRollupOp=SUM,outputUnit=GB}  [@dkcSavingCapacity rx b .*] {inputCounters=raidPool[=poolType rx Provisioning].dkcSavingCapacity, resourceRollupOp=SUM,outputUnit=GB} [=totalPGFree rx .*] {inputCounters=raidPG.totalFreeSpaceInGB, resourceRollupOp=SUM,outputUnit=GB}
  6. Click Set Report Definitions to add table data.
    The query results display the key metrics for monitoring the capacity consumption of all monitored storage systems.
  7. In the Table Data tab, select the key performance metrics that you want to monitor.
  8. To review the table report details before publishing, click Preview.
  9. Click OK.
    The new report appears on your dashboard.