Here are a few different ways to list members of an Active Directory group:
Following command will provide you first name and last name of member of a group:
dsquery group domainroot -name groupname | dsget group -members | dsget user -fn -ln
The following filter returns the members of a specific group. You have to specify the groups distinguishedName.
ldifde -f groupMembers.txt -r "(&(objectClass=User)(memberOf=CN=myGroup,OU=MyContainer,DC=myOrg,DC=local))" -l "sAMAccountName,givenName,sn"
Using Adfind (Adfind is a free tool that you can download from www.joeware.net/freetools/tools/adfind/index.htm)
TO RETRIEVE THE DN OF THE GROUP
adfind -default -f "(&(objectCategory=group)(name=<GROUPNAME>))" -dsq
or
adfind -default -f "(&(objectCategory=group)(name=<GROUPNAME>))" -dn
TO RETRIEVE THE PROPERTIES (givenName=firstname, sn=surname sAMAccountName, pre-w2k logon name, description=description, cn=full name, displayName=displayname) OF THE MEMBERS OF THE GROUP
adfind -b "<DN of group>" -asq member givenName sn sAMAccountName description cn displayName
This article was derived from the forum post Active Directory Saved Query - Group Member Listing.
This article is also available in the following languages:
Ed Price MSFT edited Revision 3. Comment: Updated title case. Minor formatting edits.
Fernando Lugão Veltem edited Revision 4. Comment: added tags
Richard Mueller edited Revision 5. Comment: Improved link to Joe Richards' adfind
Yagmoth555 edited Revision 6. Comment: great article ! adding a fr-FR link
Export to Excel with Quest AD Cmdlets:
Set-QADProgressPolicy -ShowProgress $true -ProgressThreshold 2 | Out-Null
$gr=Read-Host; $day=Get-Date -UFormat "%Y-%m-%d"; $fle=$gr+"_"+$day+".csv"; Get-QADGroupMember $gr -UseGlobalCatalog -Activity 'Retrieving group' | Sort-Object | select DisplayName,NTAccountName,Email,Company,Department | Get-Unique -asstring | Export-Csv -Encoding unicode -NoTypeInformation -path $env:temp\$fle; Invoke-Item $env:temp\$fle
I have mentioned another method using PowerShell script in the following blog:
portal.sivarajan.com/.../list-group-members-in-active.html