Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

Service Pack Level Report

How can I (with free tools/scripts) produce a report of all computers in a domain with the following 4 fields:

Computer Name
Operating System (and most importantly this must include SERVICE PACK)
Computer status (ie disabled or not)
Modieified date (to see if the computer is being used or not)

I am only really bothered about clients (desktop/laptop) and not servers, if the report can filter down.
ASKER CERTIFIED SOLUTION
Avatar of Krzysztof Pytko
Krzysztof Pytko
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pau Lo
Pau Lo

ASKER

How do you take off the default results limit again?
Oh, sorry forgot about that :) -limit 0 is required

Try this

enabled
dsquery * -filter "(&(objectClass=computer)(objectCategory=computer)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))" -limit 0 -attr Name operatingSystem operatingSystemServicePack whenChanged >>c:\enabled_comp.txt

Open in new window

       

disabled
dsquery * -filter "(&(objectClass=computer)(objectCategory=computer)(userAccountControl:1.2.840.113556.1.4.803:=2))" -limit 0 -attr Name operatingSystem operatingSystemServicePack whenChanged >>c:\disabled_comp.txt

Open in new window


Krzysztof