Configure Properties That Are Used to Create an SQL Query

The Configure DB Wizard creates entries in the CustomSettings.ini file that are used to build an SQL query. Table 191 lists the MDT properties that are used to create the query. For more information on the properties in Table 191, see the corresponding section for each property in the section, Properties, in the MDT document Toolkit Reference.

Table 191. Properties That Are Used to Create an SQL Query

Property	Description
SQLServer	Specifies the name of the computer running SQL Server to use in the query
Instance	Specifies the name of the SQL Server instance on the computer specified in the SQLServer property. If you are using: · SQL Server installed as the default instances, you can leave Instance blank · SQL Server Express, type SQLExpress for the instance name
Database	Specifies the name of the MDT DB in the SQL Server instance specified in the Instance property.
Netlib	Specifies the network library to be used in connecting to the MDT DB specified in the Database property and can be either Named Pipes (DBNDPNTW) or TCP/IP Sockets (DBMSSOCN).
SQLShare	Specifies a network shared folder on the computer specified in the SQLServer property, which is used when performing user authentication using Windows Integrated Authentication with Named Pipes protocol.
Table	Specifies the table or view to be used in the query. If you specify the Table property, you cannot specify the StoredProcedure property, too: You must specify one or the other.
StoredProcedure	Specifies the stored procedure to be used in the query. If you specify the StoredProcedure property, you cannot specify the Table property, too: You must specify one or the other.
Parameters	Specifies the selection criteria for returning rows from the query. Conceptually, this property is the WHERE clause in an SQL SELECT statement.
ParameterCondition	Specifies the Boolean operation to be performed when you specify more than one selection criterion in the Parameters property. You can select either Boolean AND (the default) or OR operations. If you want to use a Boolean OR operation, you must specify ParameterCondition=OR.
Order	Specifies the sort order of the rows returned from the query. Conceptually, this property is the ORDER BY clause in an SQL SELECT statement.

Note The SQL query that these properties create returns all columns from the table or view specified in the Table property.

Most of these properties in Table 191 were configured when you created the MDT DB. Listing 15 provides an example of CustomSettings.ini file that creates an SQL query that returns all the configuration information in the Computers view for a computer that matches the SerialNumber or AssetTag of the computer being deployed.

Listing 15. The CustomSettings.ini File After the Configure DB Wizard Has Finished

[Settings]

Priority=CSettings, Default

[Default]

OSInstall=YES

[CSettings]

SQLServer=NYC-SQL-01

Instance=SQLEXPRESS

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=SQL$

Table=ComputerSettings

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

The Priority line in the CustomSettings.ini file contains the Computers value, which directs MDT to process the [CSettings] section later in the CustomSettings.ini file. The properties in the [CSettings] section performs the query and returns the result set from the query to be used during the MDT deployment process, such as the computer name or IP address of the target computer.

You can review the tables and views in the MDT DB to determine the columns you want to reference in the Parameters property. For more information on the tables and views in the MDT DB, see the section, Tables and Views in the MDT DB, in the MDT document Toolkit Reference.