Query to show members of an AD group

You’ll often need a quick way to get the names of users in a particular Active Directory group into a text or Excel file for reporting or other reasons. You can use dsquery to achieve this easily:

dsquery group -name "group name" | dsget group -members -expand | dsget user -fn -ln

Of course you can also change the ‘dsget user -fn -ln’ to display or remove attributes, eg ‘dsget user -samid’ will show the username. You can also pipe this into a text file.

Share/Save

Possibly related posts (auto generated):

1. Copy AD group membership from one group to another
2. Windows 7 enable Recent Items via group policy
3. Set Exchange 2007 mailbox limits via group membership