Script Tips

Script Fitness

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!

About the Author

Don Jones is a multiple-year recipient of Microsoft’s MVP Award, and is Curriculum Director for IT Pro Content for video training company Pluralsight. Don is also a co-founder and President of, 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

comments powered by Disqus
Most   Popular