Generating and Maintaining Reports > Advanced Filtering for Tabular Reports
   
Version 9.1.01
Advanced Filtering for Tabular Reports
In addition to the filtering in the scope selector, table-formatted reports can be further filtered on Rows and/or Columns, using the following procedures.
Note: To optimize performance, be sure to use the filtering that’s available in the scope selector before using any advanced filtering.
To filter reports by rows
You can define the criteria for the data rows displayed in a report. Drop-down lists enable selections from the available columns. Next, you supply the operator—such as equals or does not contain—and a value for that column. Up to 16 selections can be joined to form the filter.
Filtering Limitations: Filtering on exact decimal values may produce inconsistent results, as reports display rounded values of higher-precision data. For example, a filter of MBytes equals 150.95 will return rows with rounded values. To configure a filter that more precisely narrows the content, include additional row-filtering criteria with > and < logic to limit the data that is displayed.
NOTE: Reports can have both row and column filters applied.
1. Generate a tabular report, such as the Job Summary or the VM Summary report.
2. Click Actions and select Filter.
3. Select a column name in the first drop down list.
4. Select an operator in the second drop down list
5. Click Add Filter to add up to 12 additional filters.
Operator
Description
equals1
Filters rows where the value of the associated column is equal to the value entered. The column can be of the type Number, Date or String.
not equal1
Filters rows where the value of the associated column is not equal to the value entered. The column can be of the type Number, Date or String.
greater than
Filters rows where the value of the associated column is greater to the value entered. The column can be of the type Number, Date, Duration, and File Size.
less than
Filters rows where the value of the associated column is smaller than the value entered. The column can be of the type Number, Date, Duration, and File Size.
greater than or equal to
Filters rows where the value of the associated column is greater than or equal to the value entered. The column can be of the type Number, Date, Duration, and File Size.
less than or equal to
Filters rows where the value of the associated column is smaller than or equal to the value entered. The column can be of the type Number, Date, Duration, and File Size.
contains1
Filters rows where the value entered is present anywhere in the value of the associated column. Example: If the column value is “rattle” and the value entered is “rat” or “at” the row will be displayed. The column can only be of the type String.
does not contain1
Filters rows where the value entered is not present anywhere in the value of the associated column. The column only can be of the type String.
Includes
Filters rows where the value of the associated column is equal to any of the comma-separated values entered. Example: If you enter a value “chair, table, desk” and the column value is “table” the row will be displayed. The column can be of the type Number, String, Duration, and File Size.
Excludes
Filters rows where the value of the associated column is not equal to any of the comma-separated values entered. The column can be of the type Number, String, Duration, and File Size.
matches regular expression
Filters rows where the value of associated column matches the regular expression2 entered. The column can only be of the type String. For example, to find a column starting with S, use ^S.* or ^[Ss].*
does not match regular expression
Filters rows where the value of associated column does not match the regular expression2 entered. The column can only be of the type String.
Table 4.1  
1 -is case insensitive. 2 –reference: http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Pattern.html
Filtering Indicators, Multiple Expressions, Dates, Percentages, Yes/No
• When filtering on Indicator Lights, as shown in the following example, filter on the color: Red, Yellow, Green, or Gray.
• To combine several expressions into one filter, select an and or or operator from the drop-down list at the end of the row.
• When filtering on dates, refer to Table 4.1 to determine which columns can be filtered on date. Be aware that filtering on Dates needs to be carefully designed in order to avoid degradation of performance. Date criteria can be specified in the following formats:
mm/dd/yyyy
Specified date
Now
Current date and time
Today
Current day
+nd
-nd
Enables a variable time frame (plus or minus a number of days)
For example: +2d
This criteria can be combined with Today.
For example: Today-5d
+nh
-nh
This hour option enables a selection of a date and time, plus or minus a number of hours from the current time.
For example, in the Job Summary Report, select all jobs where the Finish Time was greater than -12h. This would isolate jobs for only the last 12 hours.
• When filtering on percentages, such as in the NetApp Volume Summary Report, enter a decimal value equivalent to the percentage.
ex.
100% - 1.0
75% - .75
50% - .50
25% -.25
10% - 0.1
• When filtering on Yes/No values, enter Y or N for the values.
• Click OK to regenerate the report with the filter applied.
The report will now contain a filter applied link, enabling access to the defined filter. When you save this report, the filter is saved with it.
To filter reports by columns
NOTE: Reports can have both row and column filters applied.
1. Generate a tabular report, such as the Job Summary or the VM Summary report.
2. Click Actions and select Filter.
3. Click the Columns tab. By default, all columns are checked.
4. Uncheck the columns to remove from the report.
5. Click OK to regenerate the report with the filter applied.
The report will now contain a filter applied link, enabling access to the defined filter. When you save this report, the filter is saved with it.