Warning: The configuration, testing, and use of this monitor requires the SQL query entered to be executed which could potentially introduce security vulnerabilities into your network environment. Ensure you are using secure credentials with limited rights restricted to the database you are querying and take extreme caution when building your query. Example: When querying a Microsoft SQL Server, consider using credentials which represent a login/user who only has the "db_datareader" role for the database being queried.

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.