The Configure DB Wizard in Deployment Workbench provides a graphical interface for configuring the MDT deployment process to access the MDT DB. The advantages of using this wizard is that it helps reduce the:

·     Possibility of configuration errors in the CustomSettings.ini file

·     Effort required to modify the CustomSettings.ini file to enable retrieval of configuration settings from the MDT DB

The disadvantage of using the Configure DB Wizard is that it does not allow you to access any additional database objects that you have created, such as tables, views, or stored procedures. However, the wizard recognizes any columns that you have added to the existing tables and views.

In most instances, use the Configure DB Wizard to modify the CustomSettings.ini file. Only make direct modifications to the CustomSettings.ini file if you have added database objects, such as tables, views, or stored procedures.

Run the Configure DB Wizard for each deployment share defined in the Deployment Workbench that will be updated.

To configure CustomSettings.ini for database queries using the Configure DB Wizard in the Deployment Workbench

1.   Click Start, and then point to All Programs. Point to Microsoft Deployment Toolkit, and then click Deployment Workbench.

2.   In the Deployment Workbench console tree, go to Deployment Workbench/Deployment Shares/deployment_share/Advanced Configuration/Database (where deployment_share is the name of the deployment share to which you will add the application).

3.   In the Actions pane, click Configure Database Rules.

The Configure DB Wizard starts.

4.   Complete the Computer Options wizard page using the information in Table 187, and then click Next.

Table 187. Information to Complete the Computer Options Wizard Page

Select this check box

To do this

Query for computer-specific settings

Query the MDT DB for settings configured on the Details tab of the computer item’s Properties dialog box.

Query for roles assigned to this computer

Query the MDT DB for roles associated with the computer on the Roles tab of the computer item’s Properties dialog box.

Query for applications to be installed on this computer

Query the MDT DB for Lite Touch and Configuration Manager 2012 applications to be installed on the computer as configured on the Applications tab of the computer item’s Properties dialog box.

Query for SMS packages to be installed on this computer

Query the MDT DB for Configuration Manager packages and programs  to be installed on the computer as configured on the ConfigMgr Packages tab of the computer item’s Properties dialog box.

Query for administrators to be assigned to this computer

Query the MDT DB for user or group accounts that are to be made members of the local Administrators group on the target computer as configured on the Administrators tab of the computer item’s Properties dialog box.

 

Tip   You can click Select All or Deselect All to correspondingly select or deselect all the check boxes on the Computer Options wizard page.

5.   Complete the Location Options wizard page using the information in Table 188, and then click Next.

Table 188. Information to Complete the Location Options Wizard Page

Select this check box

To do this

Query for location names based on default gateways

Query the MDT DB for location names based on the IP addresses of the default gateways configured on the Identity tab of the location item’s Properties dialog box.

Query for location-specific settings

Query the MDT DB for settings configured on the Details tab of the location item’s Properties dialog box.

Query for roles assigned for this location

Query the MDT DB for roles associated with the location as configured on the Roles tab of the location item’s Properties dialog box.

Query for applications to be installed for this location

Query the MDT DB for Lite Touch and Configuration Manager 2012 applications to be installed on the target computers within the location as configured on the Applications tab of the location item’s Properties dialog box.

Query for SMS packages to be installed for this location

Query the MDT DB for Configuration Manager packages and programs to be installed on the target computers within the location as configured on the ConfigMgr Packages tab of the location item’s Properties dialog box.

Query for administrators to be assigned for this location

Query the MDT DB for user and group accounts that are to be made members of the local Administrators group on the target computers within the location as configured on the Administrators tab of the location item’s Properties dialog box.

 

Tip   You can click Select All or Deselect All to correspondingly select or deselect all the check boxes on the Location Options wizard page.

6.   Complete the Make/Model Options wizard page using the information in Table 189, and then click Finish.

Table 189. Information to Complete the Make/Model Options Wizard Page

Select this check box

To do this

Query for model-specific settings

Query the MDT DB for settings configured on the Details tab of the make and model item’s Properties dialog box.

Query for roles assigned to computers with this make and model

Query the MDT DB for roles associated with the make and model on the Roles tab of the make and model item’s Properties dialog box.

Query for applications to be installed on computers with this make and model

Query the MDT DB for Lite Touch and Configuration Manager 2012 applications to be installed on the target computers with the make and model as configured on the Applications tab of the make and model item’s Properties dialog box.

Query for SMS packages to be installed for this make and model

Query the MDT DB for Configuration Manager packages and programs to be installed on the target computers with the make and model as configured on the ConfigMgr Packages tab of the make and model item’s Properties dialog box.

Query for administrators to be assigned to machines with this make and model

Query the MDT DB for user and group accounts that are to be made members of the local Administrators group on the target computer with the make and model as configured on the Administrators tab of the make and model item’s Properties dialog box.

 

Tip   You can click Select All or Deselect All to correspondingly select or deselect all the check boxes on the Make/Model Options wizard page.

7.   Complete the Role Options wizard page using the information in Table 190, and then click Next.

Table 190. Information to Complete the Role Options Wizard Page

Select this check box

To do this

Query for role-specific settings

Query the MDT DB for settings configured on the Details tab of the role item’s Properties dialog box.

Query for applications to be installed for this role

Query the MDT DB for Lite Touch and Configuration Manager 2012 applications to be installed on computers that perform this role as configured on the Applications tab of the role item’s Properties dialog box.

Query for SMS packages to be installed for this role

Query the MDT DB for Configuration Manager  packages and programs to be installed on the target computers that perform this role as configured on the ConfigMgr Packages tab of the role item’s Properties dialog box.

Query for administrators to be assigned for this role

Query the MDT DB for user and group accounts that are to be made members of the local Administrators group on computers that perform this role as configured on the Administrators tab of the role item’s Properties dialog box.

 

Tip   You can click Select All or Deselect All to correspondingly select or deselect all the check boxes on the Role Options wizard page.

8.   On the Summary wizard page, review the information in the Details box, and then click Next.

9.   On the Confirmation wizard page, review the information, and then click Finish.

When the Configure DB Wizard has finished, the CustomSettings.ini file is configured to perform the selected queries. For more information about how the CustomSettings.ini file is configured using the Configure DB Wizard, see Review the CustomSettings.ini File After Running the Configure DB Wizard.

For more information about customizing each property, see:

·     The corresponding section for each property in the section, Properties, in the MDT document Toolkit Reference

For more information about customizing tables and views in the configuration database, see:

·     The section, Tables and Views in the MDT DB, in the MDT document Toolkit Reference

Related Topics

Configuring the MDT Deployment Process to Retreive Configuration Settings from the MDT DB