If you’ve ever needed to export a list of users from an Active Directory
group, you’ve probably discovered that it isn’t entirely straight
forward. The secret to generating and exporting a list are a few command
dsget. Below, you’ll see an example of a
group export. The output is fixed-width, so use Excel to break up the
data into a managable format.
You’ll only need to change
CN=Group Name,OU=Groups,DC=Example,DC=com to
fit your domain and group. If you’d like to control what fields are
exported from dsget, check out this list of
dsget on technet.
dsquery group "CN=Group Name,OU=Groups,DC=Example,DC=com" | dsget group -members | dsget user -ln -fn -samid -email > C:\Users\username\Desktop\file.csv