Using MDT database, SCCM OSD and dynamic variable list

[thadkew]

Been pulling the remainder of my hair out.

Trying to install software packages according to a dynamic variable list.

I have followed the steps of Jason Sandys in this post, and Jarvis Davis in this post

In MDT 2013, I have created the ROLES properly, adding the ConfigMgr Packages with their proper XXX00000:Program parameter.

I have set the Task Sequence Variable for ROLE to be WTS and set a Gather step before the install package.

In the SCCM 2012 task sequence, I have added an Install Package step, selected Install software packages according to dynamic variable list and given the base variable name of ROLE

I have updated the custom settings.ini file to show:

[settings]

Priority=CSettings, CPackages, CApps, CAdmins, CRoles, Locations, LSettings, LPackages, LApps, LAdmins, LRoles, MMSettings, MMPackages, MMApps, MMAdmins, MMRoles, RSettings, RPackages, RApps, RAdmins, Default

Properties=MyCustomProperty

[Default]

_SMSTSOrgName=MyCompany Inc.

OSInstall=Y

SkipCapture=YES

SkipAdminPassword=NO

SkipProductKey=YES

SkipComputerBackup=YES

SkipBitLocker=YES

EventService=http://WPS01:9800

;[DynamicPackages]

;SQLServer=WPS01

;Database=MDTDB

;StoredProcedure=RetrieveApplications

;StoredProcedure=RetrievePackages

;Netlib=DBNMPNTW

;Parameters=MacAddress

;SQLShare=DeploymentShare$

[CSettings]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=ComputerSettings

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

[CPackages]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=ComputerPackages

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

Order=Sequence

[CApps]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=ComputerApplications

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

Order=Sequence

[CAdmins]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=ComputerAdministrators

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

[CRoles]

SQLServerWPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=ComputerRoles

Parameters=UUID, AssetTag, SerialNumber, MacAddress

ParameterCondition=OR

[Locations]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=Locations

Parameters=DefaultGateway

[LSettings]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=LocationSettings

Parameters=DefaultGateway

[LPackages]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=LocationPackages

Parameters=DefaultGateway

Order=Sequence

[LApps]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=LocationApplications

Parameters=DefaultGateway

Order=Sequence

[LAdmins]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=LocationAdministrators

Parameters=DefaultGateway

[LRoles]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=LocationRoles

Parameters=DefaultGateway

[MMSettings]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=MakeModelSettings

Parameters=Make, Model

[MMPackages]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=MakeModelPackages

Parameters=Make, Model

Order=Sequence

[MMApps]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=MakeModelApplications

Parameters=Make, Model

Order=Sequence

[MMAdmins]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=MakeModelAdministrators

Parameters=Make, Model

[MMRoles]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=MakeModelRoles

Parameters=Make, Model

[RSettings]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=RoleSettings

Parameters=Role

[RPackages]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=RolePackages

Parameters=Role

Order=Sequence

[RApps]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=RoleApplications

Parameters=Role

Order=Sequence

[RAdmins]

SQLServer=WPS01

Instance=MDTDB

Database=MDTDB

Netlib=DBNMPNTW

SQLShare=DeploymentShare$

Table=RoleAdministrators

Parameters=Role

I cannot get this to actually install the packages. I receive errors in the logs like this:

Failed to run the action: Install Role Packages. Unspecified error (Error:800004005; Source Windows)

What am I missing?

[thadkew]

OK

Figured it out. I'm going to document it here so that I can find it if I need it later.

 

Step 1:

Create ROLES in MDT 2013 and add your ConfigMgr Packages to the newly created Role

Step 2:

Update the customSettings.ini file to point to the MDT Database

 

Step 3:

In the SCCM 2012 Task Sequence, add a task to install Packages and put a dot in the Install software packages according to dynamic variable list and set the Base variable name to PACKAGES. Also put a check in the box for If installation of a software package fails, continue installing other packages in the list

 

Step 4:

In the Options of the newly created Install Package step, add a task sequence variable named PACKAGES to the name of your newly created ROLE in MDT 2013

 

OPTIONS:

Add a new group with the Role Name and add the Install Package step underneath. Set the task sequence variable of the newly created group (name it PACKAGES) to the name of the MDT 2013 ROLE.
Add a GATHER step before the newly created Install Package step.

 

This seemed to work for me.