This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 71%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I have configured MDT with SQL.
and it goes like that:
User booting from PXE
Windows PE loading and processing bootstrap then cs.ini and gets information from SQL which TASKID is going to be processed with MAC address - (I've set it up just to check if everything works) so far.
For my lab, I have 2x virtual machines with different MAC and when it fires it checks DB and fires accordingly TASKID without even touching it.
[Settings]
Priority=CSettings, Default
Properties=MyCustomProperty
[Default]
_SMSTSORGNAME=xxx
OSInstall=Y
SkipCapture=YES
SkipAdminPassword=YES
SkipProductKey=YES
SkipSummary=YES
SkipRoles=YES
SkipLocaleSelection=YES
EventService=http://xxx:9800
[CSettings]
SQLServer=xxx
Instance=xxx
Database=xxx
Netlib=xxx
DBID=xxx
DBPwd=xxx
Table=ComputerSettings
Parameters=UUID, AssetTag, SerialNumber, MacAddress
SQLShare=xxx
ParameterCondition=OR
The database will be customized(in future) so I can populate it with custom JobID and PartNo that corresponds to TASKID - database itself is not a problem at this stage.
Now is a big question and I can't find any information or at least direction. I'm assuming it's going to be done with windowsPE unattend.xml during initial PXE boot but still can't find how to do what I want to with it and I'm not sure if it's the right approach.
I want to ask the user for a JobID and then it will check in the database for a PartNo that will be linked with TASKID so I can pass it back to execute it/save to "local" TaskSequenceID - that will be fired later.
Any help would be great!
Thank you
ok i think the best option as no answer (uh)
is to customize winpe loader and run script before anything kicks in and then save DB output locally somewhere on X:\CALLID.whatever.
then customize ZTIGather.wsf to load it as some variable (lets say something not important)
something like "if file exists,read and set as oEnvironment.item"
(i assuming Gather runs also just before "normal" SQL query for MAC addresss for example?)
my problem is i dont know if that will work and if it's a good approach