sihfmis said:
I have a large PC user environment that I have to find out what level of SP
all the units are running, mainly SP1. What would be the easiest way to
accomplish such a task? Preferable, I am looking at some type of script
configuration.
I tend to agree with "SPAMCOP User": the best place for your question
would be in a group like:
microsoft.public.windows.server.active_directory
or
microsoft.public.windows.server.scripting
But to avoid being totally unhelpful
... there are at least 2 ways
you can tackle this:
1) Active Directory. If it is a large environment you probably have an
Active Directory domain configured, and the workstations are joined to
the Domain. When a workstation is joined to the domain, a record (or
"object") is created in the AD database, with several attributes
describing the computer, such as operation system, OS version, and
service Pack level. So, you can run a query on AD and get the SP level
for all domain-joined workstations, without needing to interact with the
workstations at all - in other words, no need to run a script on the
workstation; the data is all there in AD on the server.
An example, chosen at random from thousands of hits in Google, is:
http://codeidol.com/active-director...uters/Finding-Computers-with-a-Particular-OS/
2) Run a Script. If for some reason you have a large PC installation
where the workstations are not joined to an Active Directory domain, or
if you want to query the workstations directly for some reason, then you
can run a script on each workstation. The Service Pack level information
is provided by WMI in the ServicePackMajorVersion attribute.
An example, once again chosen totally at random from thousands of hits
in Google, is:
http://www.cb-net.co.uk/index.php?o...service-pack-level&catid=10:vbscript&Itemid=8
There's also useful WMI info from MSFT at:
Connecting to WMI on a Remote Computer
http://msdn.microsoft.com/en-us/library/aa389290(VS.85).aspx
If you prefer to script it "old-style" and bypass vbscript, you can also
run the "SystemInfo" command at a command prompt on any XP computer:
C:\Users\Administrator>systeminfo
Host Name: XPVM1
OS Name: Microsoft Windows XP Professional
OS Version: 5.1.2600 Service Pack 3 Build 2600
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: The Manager
Registered Organization: Foobar Incorporated
Product ID: 77777-333-9999999-88888
Original Install Date: 1/08/2009, 15:46:10
System Up Time: 0 Days, 0 Hours, 42 Minutes, 17 Seconds
System Manufacturer: VMware, Inc.
System Model: VMware Virtual Platform
System type: X86-based PC
Processor(s): 2 Processor(s) Installed.
[01]: x86 Family 6 Model 23 Stepping 6
.... etc ...
You could run this in a batch file, then parse the data using your
favourite text-handling utilities.
@ECHO OFF
NET USE X:\\bigserver\SPInfo
Systeminfo > X:\%COMPUTERNAME%.TXT
NET USE X: /D
:END
Hope this helps,
Andrew
