Inventory Query from Database

Displays the query statement,which expresses the criteria you specified. The result of the query is displayed in the Query Results window.

Query the Inventory database for

Workstations
The query will locate all inventoried workstations satisfying the query expression. If you have only ZENworks® for Desktops 4 (ZfD 4) installed, this option will be enabled by default and the other two options will be unavailable.

Servers
The query will locate all inventoried servers satisfying the query expression.

If you have only ZENworks for Servers 3 (ZfS 3) installed, this option will be enabled by default and the other two options will be unavailable.

Both
The query will locate all inventoried workstations and inventoried servers satisfying the query expression.

This option is available only if you have both ZfS 3 and ZfD 4 installed.

Find Type

Quick
Queries one attribute.

Specify the attribute, relational operators, and the value of the attribute.

Advanced
Queries many attributes.

Specify the attributes, relational operators, the values, and the query connectors.

Select Attribute
Click the Select Attribute icon to select component attributes in the Select Attribute window. The components are grouped into the following categories: General, Software, Hardware, Network, and System. For example, to specify the version of BIOS as a component in the query, select BIOS as the component and VERSION as the component attribute.

Relational Operator
Relational operators show the relationship between the component and the value.

Use the Matches option to specify the wildcard characters in the Value field.

To traverse the Relational Operator button options, press Ctrl+Up-arrow or Ctrl+Down-arrow.

Value
Description values are the possible values of an inventory component.

For example, 6.0 is a possible value for the DOS-Version attribute. Description values are not case-sensitive. Use the % wildcard character to substitute any number of characters, or the ? character to substitute one character in the Value field.
The list of description values displayed for an Inventory component is taken from the Inventory database corresponding to the component.

Logical Operator
The logical operators available for building query expressions include the following:

AND
The expressions before and after the AND must be true.
OR
Either the expression before or after the OR must be true.
Insert Row
Lets you build the query for this current row.
Delete Row
Deletes the query.
New Group
Lets you form a new query group and specify the criteria for it. This query group will be combined with the previous query group by using the relational operator specified between the query groups.
End
Closes the query expression.

To traverse the Query Connectors Controls options, press Ctrl+Up-arrow or Ctrl+Down-arrow.

Find
Starts the query based on the query criteria you specified.

Clear
Clears the criteria for the query.

Save
Saves the query expression as a file in the location that you specify.

The query file does not have a default extension; however, we recommend the .QRY extension for easy reference.

Load
Loads the query file that you specify.
You must provide the full filename with its extension.



ZENworks Online Documentation

A trademark symbol (®, TM, etc.) denotes a Novell trademark. An asterisk denotes a third-party trademark. For more information, see Legal Notices.