Step 1: Creating a search condition (required)

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 query.

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
  1. Under Step 1, click Edit. A window appears showing a list that represents all of the inventory data currently in the database.
  2. 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 Computer.Software.Package.Name.
  3. 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."
  4. At the bottom of the window, click Add to fill in the empty field with your search condition.
  5. 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.
  6. 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".

Health condition Operator