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 Using Performance Monitors Performance monitors overview Using the Performance Monitor Library Working with Performance Monitors Adding and editing an Active Script Performance Monitor Adding and Editing an APC UPS Performance Monitor Adding and editing a PowerShell Scripting performance monitor Example - PowerShell performance monitor scripts Adding and editing a Printer performance monitor Adding and editing an SNMP Performance Monitor Adding and editing a SQL Query performance monitor Adding and editing an SSH Performance Monitor Adding and Editing a WMI Formatted Performance Monitor Adding and editing a WMI Performance Monitor