SqlQueryDiscoveryType Complex Type
Applies To: 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
The SqlQueryDiscoveryType complex type, in Configuration Manager 2007, describes discovery information for settings discovered from Microsoft SQL Server 2000 and SQL Server 2005.
<xs:complexType name="SqlQueryDiscoveryType">
<xs:complexContent>
<xs:extension
base="DiscoverySourceType"
>
<xs:sequence>
<xs:element name="Instance"
type="SqlInstanceNamePattern"
minOccurs="0"
maxOccurs="1"
/>
<xs:element name="Database"
type="NonEmptyStringType"
/>
<xs:element name="Query"
type="SqlQueryStringType"
/>
<xs:element name="ColumnName"
type="NonEmptyStringType"
/>
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
Child Elements
| Element | Type | Description |
|---|---|---|
The name of the column whose values will be retrieved from the result set returned in the preceding Query. This can be case sensitive depending upon the case sensitivity of the instance of SQL Server that is being connected to. |
||
The name of the database in the specified instance of the SQL Server to connect to. This can be case sensitive depending upon the case sensitivity of the instance of SQL Server that is being connected to. |
||
The name of the SQL Server instance to connect to for discovery. If the element is not specified, the default instance is assumed. If the element is specified and the value is ‘*’, all instances are enumerated and each is queried. |
||
T-SQL query string that must be executed on the specified database instance. This must be a well formed T-SQL query. |
See Also
Concepts
Authoring Desired Configuration Management Configuration Baselines and Configuration Items