Add Columns to a Table Report in ViPR SRM
Table of Contents
Table column features
In ViPR SRM, you can add new columns to a table report or edit existing column definitions. You can rearrange columns and apply filters on column values. These scenarios show several ways to add columns, including how to create multiple columns for the same metric over a specified time span.
 | This article summarizes features and illustrates specific use cases. For information about each field and descriptions of all values, see the Help embedded in the product.
|
You can view or edit column definitions for a ViPR SRM table report in EDIT MODE on the Report Details: Table tab. Each blue band on the page represents a column in the table, as the following figure shows.
| 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
- 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 TopMetrics 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:
- A value obtained from the database, as defined by a filter that you supply in the next field.
You define the filter in the Filter to Apply field. The ViPR SRM Collector and Back-End modules collect real time metrics, aggregate the collected values over various time periods, and store both raw values and aggregated values in the database. The filter definition includes fields from the database. A wizard lists field names, or you can type the filter components manually if you know them.
- The results of a formula defined on this report's child nodes.
The use a formula result option and the list of formulas populate only if formulas were previously configured on the current report's immediate child nodes. For example, on a child node to this report, in EDIT MODE, use the Formula tab to define one or more formulas. Then return to the parent report to add value columns that can use the formulas.
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:
- Sampling Period — Choose whether you want to retrieve the real-time values, or aggregated hourly, daily, or weekly samples.
- Sampling Type — Choose which aggregation type to use. Choices are: minimum, maximum, average, last sample, sum, a count, or a last timestamp. For example, you can report on the hourly maximums, daily averages, weekly counts, or perhaps the last value collected each hour.
- Column Time Ranges — Choose the time range that this column aggregation covers. Depending on your selections, you can create multiple columns that report the same metric for a set of periods within a time range. For example, you could report weekly averages on a monthly report, or hourly last values spanning a day.
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 TopAdd 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
- Log on to the Console and navigate to
.
The following image shows the pre-defined report.
- Click EDIT MODE at the top of the page.
- Click the Report Details: Table tab.
This tab shows a blue band for each defined column in the report.
- 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. - Scroll to the last blue band.
Notice that the last band is expanded, exposing fields for defining the new column.
- Define the new column as follows:
- For Column Name, type the desired column header. For example, type Hardware Product.
- 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.
- Click Save on the bottom of the page.
- To move the new column into the desired position in the report:
- Move the pointer over the blue band until the move icon appears.
- Drag and drop the blue band to its new position.
- Click Save.
- 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.
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
- Log in to the Console and navigate to
.
The following image shows the pre-defined report.
- Click EDIT MODE.
- Click the Report Details: Table tab.
- On the page that opens, click the small white arrow in the blue band for the
Last 7days Average (%) column.
- In the expanded column settings, make the following changes.
- Click the small arrow next to the Time Management section.
- In the expanded
Time Management section, make the following changes.
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:
- Scroll to the bottom of the page and click Save.
- 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.
