Skip to content

Define Report Criteria

After you have selected the items for a report, use criteria to limit the result to the units you want.

  1. Select the Reporting and Queries plugin.

  2. Select Tools → Define criteria…. You can also right-click a selected item in the tree view and select Define criteria….

    The Define Report Criteria form with the And/or, Column, Operator, and Value fields and a list of criteria

  3. Select And/or, Column, Operator, and Value for the criterion. And/or isn’t available for the first criterion.

  4. Select Add. The criterion is added to the list, and the full expression is shown below the list.

  5. Select Close.

The list always contains two built-in criteria:

Criterion Description
Show unit that does not comply Set to True to show the units that do not meet the other criteria, instead of the units that do.
Show only active units Limit the result to units with the status Active, Inactive, or Unassigned. None shows units with any status.
  1. Select two or more criteria in the list.
  2. Right-click the selected rows.
  3. Select Group selected.

To remove groups, right-click the list and select Delete selected groups or Delete all groups.

  1. Right-click a criterion.
  2. Select Edit criteria.
  3. Make your changes.
  4. Select Update.
  1. Right-click a criterion.
  2. Select Delete criteria.

To add a criterion on another item in the report, select Add new report item. For more information, go to Add new report item criteria.

To filter on unit properties such as Department, Unit State, or Business Unit, add them to the report from Unit Inventory in the Hardware tree view. For more information, go to Report static criteria.

If you want to… You can…
Create a custom made report Create a report to see how.
Preview a report Preview a report to see how.
See recent reports Select File → Recent reports. A list of the recently used reports is shown.
Set up columns Column setup to see how.
Export to reporting services Deploy to reporting services to see how.
Change column order Reporting column order to see how.
Open an existing report Open an existing report to see how.