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 Vector AM can use to select the data for this view, then select the Preview tab to check the results of the query.

To specify the selection query:

1    By default, the 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 selection conditions for the view, select the Preview tab to display the data that will be returned by your query.

8    Click Finish to close the Wizard and create the view.Building a Database Query

 

 

Related Topics

Example Queries

Using Client Properties in Filter Expressions