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.
- 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.
- Specifies the name of the Microsoft SQL Server database against which the SQL query will be run.
- 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.
- 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.
- Clears the contents of the edit box.
- Saves the changes and exits the dialog box.
- Exits the dialog box without saving any changes.
- Opens the help topic for this tab of the dialog box.