Squeeze more out of your scripts using the Microsoft Scriptomatic tool to write WMI scripts.
Want to get more scripting flexibility? Here's a way to get more out of Microsoft's Scriptomatic tool (click here
to download it), which writes Windows Management Instrumentation scripts.
First, let’s assume you have a text file named C:\Computers.txt, which contains one computer name per line. Start with this wrapper script:
Dim objFSO, objTS, strComputer
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objTS = objFSO.OpenTextFile("C:\Computers.txt")
Do Until objTS.AtEndOfStream
strComputer = objTS.ReadLine
WScript.Echo vbCrLf & "Working with " & strComputer
'paste scriptomatic code here
WScript.Echo "All done!"
Got it? Okay, now haul out the Scriptomatic and select a script. I’m choosing the Win32_OperatingSystem class for my example. Then, in the Scriptomatic itself, delete the line that reads:
strComputer = "."
And delete any of the WScript.Echo lines that refer to properties you don’t care about. For example, I only care about ServicePackMajorVersion and ServicePackMinorVersion, so I’m deleting the rest. I’m left with:
On Error Resume Next
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from
For Each objItem in colItems
Wscript.Echo "ServicePackMajorVersion: " &
Wscript.Echo "ServicePackMinorVersion: " &
Note that the word-wrapping is a little off; that’s okay. By pasting that into the indicated spot in the wrapper script I gave you, you’ve got a tool which will display the current service pack level of every computer named in C:\Computers.txt. Instant multi-computer scripting!
Don Jones is a multiple-year recipient of Microsoft’s MVP Award, and is an Author/Evangelist for video training company Pluralsight. Don is also a co-founder and President of PowerShell.org, a community dedicated to Microsoft’s Windows PowerShell technology. Don has more than two decades of experience in the IT industry, and specializes in the Microsoft business technology platform. He’s the author of more than 50 technology books, an accomplished IT journalist, and a sought-after speaker and instructor at conferences worldwide. Reach Don on Twitter at @concentratedDon, or on Facebook at Facebook.com/ConcentratedDon.