ViPR SRM 3.6 – Add Columns to a Table Report in ViPR SRM

Table of Contents

Table column features

Learn how to add new columns, edit existing column definitions, rearrange columns, and apply filters on column values in ViPR SRM table reports. Learn how to create multiple columns for the same metric over a specified time span.

Note Image
This article contains use case scenarios that summarize features and illustrate specific use cases. For information about all available fields and descriptions of all values, see the embedded Help on the Console.

In EDIT MODE, on the Report Details: Table tab, you can view, change, and add column definitions for a table report. The Report Details: Table tab contains a blue band for each column in the table. The tab also contains buttons that let you add additional columns. The following figure shows these features.

1 The white arrow exposes a column's definitions. You can view and change the column header, column formatting, and other column settings.
2 The fields in the blue bands are column_type:column_header. The column_type is either Attribute, Property, or Value.
3 These buttons add a new column to the report. After you click one of them, a new blue band appears at the bottom of the page.

Viewing Column Definitions in EDIT MODE

Column types are:
  • Attribute

    These columns display values that the system obtains from node expansion results. Examples of attribute values are node names, node IDs, or node counts (of child nodes).

  • Property

    These columns display metadata information that the system obtains from the database. Examples of properties are device, device type, array type, array name, and so on.

  • Value

    These columns display metrics that were collected and stored in the database or calculated using formulas.

Column order

To change the order of columns, drag a blue band to another location.

Back to Top

Metrics features

A value column in a ViPR SRM report retrieves metrics from the database or computes results from a selected formula. When you add or edit a value column, the UI provides a rich set of options for defining the value that is retrieved or computed.

You can view these settings for an existing value column in EDIT MODE, on the Report Details: Table tab. To expose a column's settings, click the white arrow In the blue band for the column of interest, as the following figure shows.

Viewing Settings for a Value Column

The Selected Value field defines the metric value to appear in this column's cells. The metric in a value column is one of the following:

Other settings for the column are organized under section titles. For example, the Time Management section further defines the metric value. Some of the variables in the Time Management section are:

The Value Settings section includes threshold definitions. You can add new thresholds on the column, edit existing threshold values, and delete thresholds.

Other settings control the appearance of the value. For example, you can specify rounding attributes and whether to replace empty values with zero.

Back to Top

Add new column in the middle of a table report

This scenario shows how to add a new column to an existing table report in ViPR SRM.

Assume that you are a storage administrator researching future storage asset needs. You are using the Storage Pools report but want to include the hardware product names associated with each array. This scenario shows how to add a column called Hardware Product next to the Array Name column.

Procedure

  1. Log on to the Console and navigate to Explore > Storage > More Reports > Storage Pools.
    The following image shows the pre-defined report.
  2. Click EDIT MODE at the top of the page.
  3. Click the Report Details: Table tab.
    This tab shows a blue band for each defined column in the report.
  4. To add the new column to this report, click the Property button near the top of the page.
    The system adds a new blue band at the bottom of the page.
  5. Scroll to the last blue band.
    Notice that the last band is expanded, exposing fields for defining the new column.
  6. Define the new column as follows:
    1. For Column Name, type the desired column header. For example, type Hardware Product.
    2. For Property, you can type the property if you know the exact string. Otherwise, click the list icon, select a value, and click Apply. For this example, we want the property called arraytyp.
    3. Click Save on the bottom of the page.
  7. To move the new column into the desired position in the report:
    1. Move the pointer over the blue band until the move icon appears.
    2. Drag and drop the blue band to its new position.
    3. Click Save.
  8. To regenerate and view the report with the new column, click BROWSE MODE at the top of the page.
    The system regenerates the report, populating values in the new column.
Back to Top

Create multicolumn timespan on a metric

This scenario shows how to use ViPR SRM to create a set of columns showing values for the same metric in sequential periods over a defined timespan.

Assume that you are a system administrator researching peaks in CPU usage and potential ways to equalize usage. You start by examining the CPU Utilization report, which shows CPU usage as a percentage over the past 7 days.

To determine if certain days of the week consistently experience more activity than other days, you want to transform the Last 7 Days Average (%) column into 7 columns showing the maximum daily utilization for a 7-day timespan.

This scenario shows how to create multiple columns showing the values of a metric for each day in the current week.

Procedure

  1. Log in to the Console and navigate to Planning > Detect Hot Spots Proactively > CPU Utilization.
    The following image shows the pre-defined report.
  2. Click EDIT MODE.
  3. Click the Report Details: Table tab.
  4. On the page that opens, click the small white arrow in the blue band for the Last 7days Average (%) column.
  5. In the expanded column settings, make the following changes.
  6. Click the small arrow next to the Time Management section.
  7. In the expanded Time Management section, make the following changes.
    Note Image
    In the Column Time Range field:
    • current generates columns for the current week. If you run the report on Wednesday, there are no columns for Thursday, Friday, and so on.
    • last generates a column for each day of the past week and the current day. If you run the report on Wednesday, there are 8 columns, one for each day from the previous Wednesday to the current Wednesday.

    The Time Management section now looks like this:
  8. Scroll to the bottom of the page and click Save.
  9. To view the changed report, click BROWSE MODE at the top of the page.
    The system generates the new report, which includes multiple Maximum Utilization columns. The following example was run on Wednesday.
Back to Top