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:
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*))"
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