SQL Query Builder
This dialog assists in developing proper query syntax for SQL Query active monitors.
To use the SQL Query Builder:
- From the Select a ADO/Windows Credential dialog, select the ADO or Windows credential you would like to use to build the query from the list or click browse () to select from the Credentials Library.
- Click . The SQL Query Builder dialog appears.
- Select the database you want to use to build the query in the box.
- Select the database table you want to use to build the query in the box.
- Select the database columns you want to use to build the query in the box.
- . Select this option to select all of the columns in the database table.
- . Select this option to clear the selection of the columns in the database table.
: As you specify the database query selections, the box updates to verbally illustrate the query you have configured.
- Click to save changes.