SQL Query Builder

This dialog assists in developing proper query syntax for SQL Query performance 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 column you want to use to build the query in the Columns box.

   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 Creating custom performance monitors Creating device-specific Active Script performance monitors Creating device-specific APC UPS performance monitors Creating device-specific PowerShell Scripting performance monitors Example - PowerShell performance monitor scripts Creating device-specific SNMP performance monitors Creating device-specific Printer performance monitors Creating device-specific SQL Query performance monitors Creating device-specific SSH performance monitors Creating device-specific WMI Formatted Counter performance monitors Creating device-specific WMI performance monitors Example: monitoring router bandwidth Example: troubleshooting a slow network connection