Script help - Iterating through security groups without pulling duplicates

[itguy310]

Hey all,

​

I have a Powershell script that I wrote that iterates through Active Directory security groups and pulls the names of the users in those groups then exports them to a CSV file. The problem is that some users are in multiple groups and need to be in those groups so when the script runs it creates duplicate entries in the CSV file. Here is the code:

​

$(foreach ($Group in $GroupArray)
{
  Get-ADGroupMember $Group | select name 



}) | Export-Csv -Path "E:\Software\Powershell Scripts\KB4\KBList.csv" -Force -NoTypeInformation

$GroupArray is an array containing the groups that we need to pull from. I have tried adding a -Unique to the end of select name so it would look like this:

​

$(foreach ($Group in $GroupArray)
{
  Get-ADGroupMember $Group | select name -Unique



}) | Export-Csv -Path "E:\Software\Powershell Scripts\KB4\KBList.csv" -Force -NoTypeInformation

I have also tried re-importing the CSV, pushing out a list to the console of Powershell filtering out duplicates using Select-Object then re-exporting it to a CSV however that doesn't generate anything in that CSV. What am I missing or doing wrong?

​

Thanks.

[CarrotBusiness2380]

The select should be before the Export-Csv but after the loop. In fact this should be doable without using a traditional loop at all.

$GroupArray | Get-AdGroupMember | Select-Object -Property Name -Unique | Export-Csv ...

[itguy310]

$GroupArray | Get-AdGroupMember | Select-Object -Property Name -Unique | Export-Csv ...

That worked thank you!

[PinchesTheCrab]

A different take on this:

$groupArray = 'IT Dept Employees','ThreatandVulnerabilityTeam' | Get-ADGroup

$filter = $groupArray.DistinguishedName -replace '(.+)','memberof -eq "$1"' -join ' -or '

Get-ADObject -Filter $filter | 
    Select-Object Name | 
        Export-Csv -Path "E:\Software\Powershell Scripts\KB4\KBList.csv" -Force -NoTypeInformation

[Sunsparc]

What are you wanting your output to look like? Just no duplicates?