A search condition is a set of inventory attributes and
associated values that you query for. You can use one search
condition or group several together to form the basis of a
The following steps take place on the Edit query page.
From the Custom queries view, click New, or select an
existing query and click Edit.
To create a search condition
Under Step 1, click Edit. A window
appears showing a list that represents all of the inventory data
currently in the database.
Drill down this list to select the attributes that
will be your search condition. For example, to locate all clients
running a particular type of software, you would select
After selecting the attributes, you'll notice that a
series of fields appear in the right side of the window. From these
fields, select an operator and value to complete the search
condition. For example, to locate all clients running Internet
Explorer 6.0, the attributes would be
"Computer.Software.Package.Name," the operator "=," and the value
"Internet Explorer 6."
At the bottom of the window, click Add to fill
in the empty field with your search condition.
You can continue to refine the query by creating
another search condition, then adding it to the first with a
boolean operator (AND or OR). Also use the buttons to add, delete,
replace, group, or ungroup the conditions you create.
When you're finished, click OK.
To run and store a query on the health status of servers
(Computer.Health.State), you should be aware that the state in the
database is represented by a number. Use the table below to create
search conditions. For example, to create a search condition for
machines with "Unknown" health, use the operator "NOT EXIST".