Step 1: Creating a search condition [Web console]

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. In the Web console toolbox, click Reporting > Queries.
  2. On the toolbar, click New, or select an existing query and click Edit.
  3. Under Step 1, click Edit. A window appears showing a list that represents all of the inventory data currently in the database.
  4. 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.
  5. After selecting the attributes, you'll see a series of fields 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 7.0, select the attributes "Computer.Software.Package.Name", the operator "=", and the value "Internet Explorer". Select the Boolean operator AND, then click Add. Select the attributes "Computer.Software.Package.Version", the operator "LIKE", and the value "8", and click Add.
  6. 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.
  7. When you're finished, click OK.

NOTE: 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

Unknown

NOT EXIST

Normal

2

Warning

3

Critical

4