Forum Discussion
Need help exporting list of enabled group members
So I have this simple one line that exports the members of a group. Get-ADgroupMember GroupName -Recursive | select Name | Sort-Object -Property Name | export-csv -Path \\domain.local\share...
Baron164 Piping like that doesn't work (You're not using a Foreach in it), I changed it to something somewhat longer which also displays the group name in the CSV file
$total = @()
$group = 'Group1'
foreach ($user in Get-ADgroupMember $group -Recursive | Where-Object objectClass -eq user ) {
if ((Get-ADUser $user.SamAccountName).enabled -eq 'True') {
$founduser = [PSCustomObject]@{
Group = $group
User = $user.name
}
$total += $founduser
}
}
$total | Export-Csv -Encoding UTF8 -Path \\domain.local\share\exportmembers.csv -NoTypeInformation -Delimiter ';'
So it's only providing me with two user accounts, which is the same that I was getting. My initial line when it's exporting everything returns over 100 users. But when I try to specify only enabled users I only get two listed. The group I'm currently trying to export from has a lot of nested groups within it.
- (Get-ADgroupMember $group -Recursive | Where-Object objectClass -eq user).count is how many?
- 659
- Strangely enough, didn't expect that, on my test DC get-ADgroupMember group1 -Recursive gives me three accounts, two directly in group1 and one in the nested group2. get-ADgroupMember group1 gives me three members, two accounts, and one group.
What does (Get-ADgroupMember $group -Recursive).count give you?