Setting filters for custom reports

Filters let you customize reports to include only the information that meets specific criteria. You can filter on any field that is available for the report category, including fields that you do not want to include on the report.

For example, if you want to create a report that lists jobs that ran on the media server named Test Server, you can set up the following filter:

Field name

Media Server

Operator

= (Equal)

Value

Test Server

Since the report lists all jobs that ran on Test Server, the Media Server field does not need to display on the report. However, you might consider adding the media server name to the report name.

To set filters for custom reports

  1. On the navigation bar, click Reports.

  2. In the tree view, click Custom Reports.

  3. In the reports list, click the report that you want to filter.

  4. On the task pane, click Edit.

  5. On the properties pane, under Report Definition, click Filters.

  6. Complete the options as follows:

    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.

  7. Click Add.

  8. Repeat step 6 and step 7 to add more filters.

  9. To combine sets of filter expressions, do any of the following:

    To combine two filter expressions so that both expressions must be true for the result to be true

    Click AND.

    For example, to find all backup jobs that failed, add the following expressions:

    • Status = Failed

    • Type = Backup

    After you set up the expressions, do the following:

    • Click AND to combine the two expressions.

    The combined expression is:

    Status = Failed AND Type = Backup

    To combine two filter expressions so that one of the expressions must be true for the result to be true

    Click OR.

    For example, to find jobs that either failed or were canceled, add the following expressions:

    • Status = Failed

    • Status = Canceled

    After you set up the expressions, do the following:

    • Click OR to combine Status = Failed with Status = Canceled.

    The combined expression is:

    Status = Failed OR Status = Canceled

    To combine two filter expressions into a single expression

    Click ( ) +

    For example, to find backup jobs and restore jobs that failed, add the following expressions:

    • Status = Failed

    • Type = Backup

    • Type = Restore

    After you set up the expressions, do the following:

    • Use OR to combine Type = Backup with Type = Restore.

    • Press and hold Ctrl while you click Type = Backup and Type = Restore.

    • Click ( ) + to combine Type = Backup with Type = Restore.

    • Use AND to combine Status = Failed with (Type = Backup OR Type = Restore).

    The combined expression is:

    Status = Failed AND (Type = Backup OR Type = Restore)

    To separate two filter expressions that were combined into a single expression

    Click ( ) -

    For example, if you used ( ) + to combine Type = Backup with Type = Restore, it is displayed on the Filters dialog box like this:

    (Type = Backup OR Type = Restore)

    To make the combined expression into two individual expressions, do the following:

    • Press and hold Ctrl while you click both Type = Backup and Type = Restore.

    • Click ( ) -

    After you separate the expressions, they are displayed without the parentheses.

  10. To change any of the expressions, do the following in the order listed:

    • In the Filter criteria box, select the expression that you want to change.

    • Click Edit.

    • In the Filter expression area, edit the expression's values.

    • Click Update.

  11. To remove an expression, select the expression, and then click Remove.

  12. Do any of the following:

    To group fields for the report

    Do the following in the order listed:

    To sort fields for the report

    Do the following in the order listed:

    To set graph options for the report

    Do the following in the order listed:

    To preview and test the report

    Do the following in the order listed:

    • On the properties pane, under Preview, click Preview.

    • To test the report, on the Preview dialog box, click Test Report.

    To finish and close the report

    Click OK.