Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Premier Sign In Partner Program Sign In

Dell EMC OpenManage Enterprise Version 3.3.1 User's Guide

PDF

Select query criteria when creating reports

Define filters while creating query criteria for:
Define the query criteria by using two options:
  • Select existing query to copy: By default, OpenManage Enterprise provides a list of built-in query templates that you can copy and build your own query criteria. A maximum of 20 criteria (filters) can be used while defining a query. To add filters, you must select from the Select Type drop-down menu.
  • Select type: Build query criteria from scratch using attributes listed in this drop-down menu. Items in the menu depend on the devices monitored by OpenManage Enterprise. When a query type is selected, only appropriate operators such as =, >, <, and null are displayed based on the query type. This method is recommended for defining query criteria in building customized reports.

    NOTE: When evaluating a query with multiple conditions, the order of evaluation is same as SQL. To specify a particular order for the evaluation of the conditions, add or remove parenthesis when defining the query.

NOTE: When selected, the filters of an existing query criteria is copied only virtually to build a new query criteria. The default filters associated with an existing query criteria is not changed. The definition (filters) of a built-in query criteria is used as a starting point for building a customized query criteria. For example:

  1. Query1 is a built-in query criteria that has the following predefined filter: Task Enabled=YesTask Enabled=Yes.
  2. Copy the filter properties of Query1, create Query2, and then customize the query criteria by adding another filter: Task Enabled=YesTask Enabled=Yes AND (Task Type=Discovery)(Task Type=Discovery).
  3. Later, open Query1. Its filter criteria still remains as Task Enabled=YesTask Enabled=Yes.

  1. In the Query Criteria Selection dialog box, select from the drop-down menu based on whether you want to create a query criteria for Query groups or for report generation.
  2. Add or remove a filter by clicking the plus or dustbin symbol respectively.
  3. Click Finish.
    A query criteria is generated and saved in the list of existing queries. An audit log entry is made and displayed in the Audit logs list. See Manage audit logs.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\