SQL Query Setting Properties: General Tab

Aplica-se a: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

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.

noteNota
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.

Consulte Também

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.

Conteúdo da Comunidade

Mostrar: