Enter Database Query
The Enter Database Query dialog enables you to create database queries using simple, English statements. Use the Natural language query tab to specify criteria that the system can use to select the members of this group, then select the Preview tab to check the results of the query.
To create a Client selection query:
1 By default, the Group Wizard creates a SQL statement that selects data which matches all the conditions specified in the query. If you want to change the type of query, click all and choose a new Comparison Operator.
2 Click < Click here to add new condition >. The Wizard creates a default query.
3 In the default query, click the Field Selector, and select the database field you want to search from the drop-down list.
4 Click the Condition Selector and select the test that you want to use to select data.
5 Click the Condition Value at the end of the condition, and enter the value you want to identify.
You can use the * and % characters as wildcards. For example, to select from all entries in the NODENAME field, type *; to select all PCs with names that start with J, type J%.
6 To add another condition repeat steps 2 through 5.
To add a nested condition, right-click < Click here to add new condition > and choose Open new bracket.
To temporarily remove a condition from the query, deselect the check box at the left of the line.
To delete a condition, click the Condition Identifier and choose Delete Current Row.
7 When you have specified all the Client selection conditions for the group, select the Preview tab to list the Clients that will be returned by your query.
8 Click Next to continue.
Related Topics