Use the General tab of the Configuration Manager 2007 SQL Query Setting Properties to define your own name and description of this setting, and to define the SQL query that will be used to assess compliance on client computers.

This tab contains the following elements:

Display name

Specifies the name of the SQL query setting you will see in the Configuration Manager 2007 Administrator console.
Description

Specifies the description for the SQL query setting. The description should give an overview of the SQL query setting and other relevant information that helps identify it among other SQL query settings.
Use default instance

Specifies that the SQL query should be run against the default instance of Microsoft SQL Server that is running on the client computer.
All instances

Specifies that the SQL query should be run against all instances of Microsoft SQL Server that are running on the client computer.
Instance name

Specifies that the SQL query should be run against the specified named instance of Microsoft SQL Server that is running on the client computer.
Note
The instance name must refer to a local instance of SQL Server. To refer to a clustered SQL server instance, you should use a script setting.
Database

Specifies the name of the Microsoft SQL Server database against which the SQL query will be run.
Column

Specifies the column name returned by the T-SQL statement that will be used to assess compliance.
T-SQL statement

Specifies the full SQL query in an edit box for the SQL query.
Open

Opens a browse dialog box to select a file with a .SQL extension that contains the SQL query and add its contents to the edit box.
Clear

Clears the contents of the edit box.
OK

Saves the changes and exits the dialog box.
Cancel

Exits the dialog box without saving any changes.
Help

Opens the help topic for this tab of the dialog box.

See Also