White Papers

Creating Query Groups and Report Definitions
12 Define Custom Groups and Reports in Dell EMC OpenManage Enterprise
In some cases, when an option is selected in the Operator control, the Value control appears to the right of
the Operator control, allowing a required value to be entered or selected. The Value control also varies
depending on the data type of the selected Field Name. For example, if a numeric field is selected, the Value
control allows only numbers to be entered. Some fields, such as Status fields, are required to have specific
values. In these cases, the Value control is a drop-down menu from which a valid option must be selected.
Note—In some cases, a field may not have any value for a particular device (or other item). For example, it may be that a
device does not have an Asset Tag value. The “is null” and “is not null” options in the Operator drop-down menu enable
the query to specify devices where a particular field has a value or where a particular field does not have a value.
When the operator “is null” or “is not null” is selected, a Value control is not displayed because the value is
expressed as a part of the operator.
The following table shows the different data types that a field may have, the applicable operators to each data
type, and the type of Value control for each data type:
Field Data Types and Operators
Field Data Type
Operators
Value Control
Timestamp
=, !=, before, after,
is null, is not null
Date selector and time selector controls
String
=, !=, <, <=, >, >=,
begins with, ends with,
contains, does not contain,
is null, is not null
Text control – any text may be entered, up to
the field’s maximum length
Number
=, !=, <, <=, >, >=,
is null, is not null
Spinner control; allows a number to be
entered
Value Set
=, !=, is null, is not null
Drop-down containing allowed values
2.3.3 Query Criteria Selection–Multiple entries
The Query Criteria Selection page allows a query to contain multiple conditions (up to 20 of them, which
should be more than would ever be required). The page also supports building complex logical expressions
using the individual conditions.
Figure 6 indicates query criteria containing two conditions, each of which must be satisfied for a device to be
included in a Query Group or report output:
Multiple
conditions in a
query
•Each condition after the first one begins with a drop-down menu with options “AND” and “OR”:
•AND-Indicates that a device is included in the group or a result row is included in a report—only if
both the previous condition and the current condition are satisfied (that is, both are true).
•OR-Indicates that a device is included in the group or a result row is included in a report—if either
the previous condition or the current condition is satisfied (that is, either is true).