Filter expressions for defining custom reports

You can create a filter by defining one or more filter expressions

See Setting filters for custom reports .

Table: Filter expressions for defining custom reports

Item

Description

Show advanced fields

Check Show advanced fields to see all of the fields that are available for filtering. By default, only the most common fields display.

Field name

Select the field on which you want to filter.

Operator

Select the appropriate operator for this filter. Operators determine how the field name and the value are linked. The following operators are available in Backup Exec, but the list that displays varies depending on the type of field you selected in Field name:

  • = (Equal). The field name must equal the value.

  • <> (Not Equal). The field name must not equal the value.

  • > (Greater Than). The field name must be larger than the value.

  • >= (Greater Than or Equal). The field name must be larger than or equal to the value.

  • < (Less Than). The field name must be smaller than the value.

  • <= (Less Than or Equal). The field name must be smaller or equal to the value.

  • $ (Contains). The field name contains the text entered in the Value field.

  • NOT$ (Contains). The field name does not contain the text entered in the Value field.

  • IN LAST. A date or time window that is relative to the time that you create the report. This operator defines dates and times prior to the time when the report is created. This operator is available only for date and time fields.

    If you enter hours in the Value field you receive more specific results than if you enter days. The Day value is calculated beginning at midnight (00:00) yesterday and ending at the time when the report runs.

    For example, if you enter 1 day in the Value field and the report runs at 23:59 today, the report includes results for the last 47 hours and 59 minutes. However, if you enter 24 hours, you receive information for exactly 24 hours prior to the time when the report runs.

  • IN NEXT. A date or time window that is relative to the time that you create the report. This operator defines dates and times after the time when the report is created. For example, to find backup jobs that are scheduled to occur during the next three days, select this operator, and then enter 3 days in the Value field. This is available only for date and time fields.

Value

Type or select the value on which you want to filter. The type of value that you can enter varies depending on the type of field name that you select. For example, if you select Next Due Date in the Field name, Backup Exec displays date and time values.

Filter expressions for defining custom reports