The SQL Query Builder 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 for which you want to build the query or click browse (...) to select credentials 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.

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

  6. Click OK.