Remotely Discover Windows XP Service Pack Level

[_techie_]

Hi,

 

Is there anyway to remotely discover a workstations Service Pack Level, without resorting to Spiceworks?

 

We just need to find out quickly, since we are doing an inplace upgrade to Office 2010, and it requires Windows XP SP3.

 

Cheers,

[kmount]

If quickly (as in in the next few mins) try Remote systems info from Free Remote System Information Download (use the second mirror, the official one is long gone)

[danrhodes]

You can find this in AD under the Operating System tab of a machines properties!

[ChrisH]

Plenty of script examples out there. Just change the computer name.

 

Const Impersonate = "winmgmts:{impersonationLevel=impersonate}!\\"
computer = "."
Set oWMI = GetObject(Impersonate & computer & "\root\cimv2")
Set QueryWMI = oWMI.ExecQuery("SELECT * FROM Win32_OperatingSystem")
For Each oItem In QueryWMI
spVer = oItem.ServicePackMajorVersion
Next

MsgBox "This computer has Service Pack " & spVer & " is installed."

[CESIL]

windows system information app can do this

[_techie_]

Cheers guys, I had forgotten about AD!...

Is there an easy way to query AD for those machines which have Service Pack 2?

Ta

[danrhodes]

I've attached a predefined AD query, just open it up in an XML editor, put in your corruct OU information and import it into AD then let it run and it will filter out all machines on Service Pack 2.

 

D

ServicePackQuery.zip

[_techie_]

Cheers Dan, muchos appreciated. I tried using Find in AD, but you can only view Operating System Field, not Service Pack.

[danrhodes]

A nice little tutorial here - Using Saved Queries