“There are no limits to what you can accomplish when you are supposed to be doing something else."

Menu

PowerShell Tip – Running a Service Pack Report – Faster

Imagine you wanted to run a quick report of all your server’s service pack level in your domain. After all, SP1 just came out! You could get this information quickly by using the Active Directory Module for Windows PowerShell. If you don’t have at least one Windows 2008 R2 (RTM or SP1) Domain Controller, you could also do something similar with the free Quest PowerShell tools, but that’s for another day…

We can find this information using a few different methods. Here I’ll show two:

You can see with Method 1, we’re telling PowerShell to get all the computer accounts from Active Directory. Then we pass those objects over to the “Where-object” cmdlet and ask it to select only those who have an OperatingSystem attribute containing “server”. We then format the results in a table. Give it a try.