SQL Query Builder

This dialog assists in developing proper query syntax for SQL Query active monitors.

To use the SQL Query Builder:

  1. 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.
  2. Click OK. The SQL Query Builder dialog appears.
  3. Select the database you want to use to build the query in the Database (Catalog) box.
  4. Select the database table you want to use to build the query in the Table/View box.
  5. Select the database columns you want to use to build the query in the Columns box.
    • Select All. Select this option to select all of the columns in the database table.
    • Deselect All. Select this option to clear the selection of the columns in the database table.

    Note: As you specify the database query selections, the SQL Query box updates to verbally illustrate the query you have configured.

  6. Click OK to save changes.

See Also

Adding and editing a SQL Query active monitor