Querying Computers in Active Directory

If you need to do some reports in active directory best tool for use is DSQUERY which is part of Remote Server Administrative Tools

First common query is how to list all computers spreaded in different Ous

And here it is:

dsquery computer

As dsquery shows first 100 results option for showing more is:

dsquery computer –limit 1000

This will show first 1000 computers in your active directory. If You have more than 1000 computers just change number.

If You need this for some reports You can put results in a text file and later on import it to excel

Syntax for this is:

dsquery computer –limit 1000 >computers.txt

If You need to know which computer is running which OS syntax will be:

dsquery * domainroot -filter "(&(objectCategory=computer)(operatingSystem=Windows XP*))"

OR

dsquery * domainroot -filter "(&(objectCategory=computer)(operatingSystem=Windows Server*))"

For those who wants to know what service pack is on those OS:

dsquery * -scope subtree -attr "cn" "operatingSystem" "operatingSystemServicePack"  -filter "(&(objectclass=computer)(objectcategory=computer)(operatingSystem=Windows XP*))" -limit 100000

Last two syntax is announced on sheenaustin.com

Advertisements