Changing a computers asset tag in the MDT database

My brother (Stefan van Bruggen) wrote this function for me. I will be using this function in my script(s) that I’m writing to allows my customers and co-workers to add and change various information without manually manipulating the MDT SQL database.

The script uses the MDTDB module created by Michael Niehaus (which can be found HERE). This module allows you to change a lot of information in the database except for the asset tag.

Add this to the MDTDB.psm1 to be able to change the asset tags and the other scripts, which I will post on here soon.

 

Use WMIC to get the exact model/make of your computer

A short tip and note to myself. A quick way to get the exact model and manufacturer from a Windows PC using the command line.

This command gives me all the information I need to add the client for MDT deployments..

We usually configure MDT to look for the Model + Manufacturer to locate the drivers needed for the computer. We will add a driver group on the MDT Deployment share and inject the drivers in the MDT Task Sequence to filter the drivers like ‘Windows 7 x64\%make%\%model%. These are Windows variables.

This will give us the following folder tree for the Out-of-Box Drivers folder in MDT.

MDTdrivesr

 

Request an overview of installed Microsoft Hotfixes using Powershell

One of my customers requested a overall view of the servers where one or more Microsoft Hotfixes were installed. I’ve used a small and simpel PowerShell script to do that.

This scripts uses a text file (serverlist.txt) to check which servers it needs to use to look for the Hotfix(es). Place each server ona  different line. I have placed the text file on d:\ServerLixt.txt. Use it like this:

server1
server2
server3
..etc

GetHotfix.ps1 generates a overview of installed hotfixes (in this case KB2486635) on the requested servers.

Looking up multiple hotfixes is possibile to extend the script with multiple ‘KB12345678’. For more information about the Get-Hotfix command: slook here.