[mdt] MDT & SQL Database

[tri_94]

Hi there

 

Having never used MDT and SQL database together just wondering in how people use it?

 

Also is it possible for a new pc to prompt for a computer name and ou etc and have that data along with the serial number wrote back to the database?

 

I know the Linux Project Fog has an inventory setting which you can do this type of thing.

 

Many thanks

[Boredguy]

The way we use it, is we get the workstation mac address, and using a csv file and powershell, add the workstation into the database filling in some of the details like screen resolution, station name, OU location, admin credentials for the build and the task sequence.

 

Then when we boot the workstation, we do not have to enter any details after selecting the litetouch image, as it's all stored in the database.

[computer_expert]

I use the DB pretty much in the same way as boredguy. I use the service tag here (dell) as I find it more reliable after machines have had a NIC swap when the internal one self destructs! Be careful if you use lenovo machines, as they do some weird and wonderful stuff with WMI (where MDT gathers some information from)

 

The roles part is quite handy as I can then say that dells get (for example) the command update suite of programs and HP get their management utilities. You can then break it down further so that elitedesk 800s get put in a certain OU with a specific admin password and optiplex 3070s get put in a different OU with a different admin password and organisation name.

[tri_94]

Thank you both for your info.

 

Its just having have used the likes of Project Fog. The way in which I can have a new pc and pxe and then it adds the pc to database is a really useful thing.

 

I think I've found that MDT can do this

 

https://deployvista.com/2010/09/17/insert-computers-automatically-into-the-mdt-database/

[tri_94]

Does anyone use a web front end ?

 

Thanks