Filtering the Resources that Appear in a Report

Use the Edit Filter window to apply conditions to the columns within a report to further select or restrict objects on which you want to report. Filters enable you to apply general rules to the report. For example, you can show only the filesystems that contain over 80% used space, or show computers that match "w2s-*", or select all disks with percent used space >= to a specific value.

The following table describes the fields that appears on the Edit Filter window:

Field Name

Description

Add

Press this button to specify multiple conditions for the filter. When you click Add, report columns will be displayed enabling you to define conditions for those columns.

Delete All

Press this button to delete all the conditions displayed on the table.

Case-sensitive string comparisons

Check this box to ensure that values appearing in the generated report match the case of the values entered in the Value 1 and Value 2 fields.

Records must meet

 

Use this field to specify how the conditions in the filter are grouped together.

  • All conditions. All of the entered conditions (rows on the dialog box), must be true in order for the record to show up as a row in the report.
     

  • At least one condition. At least one of the entered condition must be true in order for the record to show up as a row in the report.

Column

Use this field to select specific columns on which you want to define conditions. The drop-down lists the columns available for the report. As you select the column from the drop-down list, it is displayed on the table, and the column name is removed from all the other drop-down list.

Click to delete the column.

Operator

Select the condition's operator. Not all operators apply to all the column data-types.

Value 1/
Value 2

 

Specify fixed value(s) to be compared against the record's column value.

Depending on the operator and data-type, this field may be absent or display-only. If the field is display-only, an Edit button will be enabled. If both this field and the Edit button are enabled, this field allows shorthand value entry. If you click the Edit button, a dialog box is displayed to provide more assistance in editing the value.

A Value 2 field will be present only for (NOT) BETWEEN.

Edit

Click this button to edit values pertaining to size, date, and for specific values used for IN, LIKE, etc. operators. Depending on the condition you are creating, a dialog box displays to help you to enter values that correspond to the condition.

OK

Click this button to save the filter. You are returned to the Selection tab. The Filter button will display a red triangle to indicate that a filter has been defined for the report.

Cancel

 

Click this button to return to the Selection tab without saving the filter.

 

Related Topics

Working with Reports

Selecting a Report

Selection Tab

Selecting Resources Upon Which to Report

Filtering the Resources that Appear in a Report

Generating a Report

Sorting Columns

Drilling Down a Report Row

Navigating Tabs

Generating a Report Chart