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: On the properties pane, under Report Definition, click Grouping. Complete the appropriate grouping options. See Grouping fields in custom reports.
    To sort fields for the report	Do the following in the order listed: On the properties pane, under Report Definition, click Sorting. Complete the appropriate sorting options. See Sorting fields in custom reports.
    To set graph options for the report	Do the following in the order listed: On the properties pane, under Report Definition, click Graph Options. Complete the appropriate graphing options. See Setting graph options in custom reports.
    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.