How to export group membership of entire users in an OU to CSV

Question

Hi guys, how can someone with PS expertise help me with include the script to export surname, given name + descriptions ?

# Import Modules  
import-module activedirectory  
# Empty Array  
$Array = @()  
  
# Get your users  
$Users = (get-aduser -filter * -searchbase "OUPath" ).samaccountname  
# Loop through the users  
foreach ($user in $users) {  
# Get Users' Groups  
  $groups = (get-aduser $user -Properties memberof).memberof  
# Make a new object with the findings  
$NewObj = New-Object System.Object  
    $NewObj | Add-Member -type NoteProperty -Name "SamAccountName" -Value "$user"  
    $NewObj | Add-Member -type NoteProperty -Name "Groups" -Value "$groups"  
# Add the object to an array (one at a time)  
$Array += $NewObj  
                            }  # End Loop  
# Dump filled array to a file  
$Array | export-csv "GrpMembers.csv" -NoTypeInformation  

  

Answer 1

You could try this. Be sure to remove (or just comment out) one of the ways to create the CSV (one row per user/group, OR one row per user with all groups):

Get-ADUser -Filter * -SearchBase "OU" -Properties memberOf |
    Foreach-Object{
        # $_ represents a user object
        $var = [PSCustomObject]@{
                SID = $_.SamAccountName
                Name = $_.Name
                Group = ""
            }
        # create one row for each user/group combination
        $_.memberOf  |
            ForEach-Object{
                # $_ represents a group's distinguishedName
                $var.Group  = (Get-ADGroup $_).samaccountname
                $var
            }
        #  ---- OR ------
        # create one row for each user, all groups in "Group" column, each separated by ';'
        if ($_.memberOf){
            $groups = @()
            $_.memberOf |
                ForEach-Object{
                    $groups += (Get-ADGroup $_).samaccountname
                }
            $var.Group = $groups -join ';'
            $var
        }
    } | Export-Csv -Path C:\Temp\GrpMembers.csv -NoTypeInformation

Answer 2

$results = @()
$Users = Get-ADUser -Filter * -SearchBase "OU"
foreach ($User in $Users) {  
    $currentUserGroups = (Get-ADUser $User.samaccountname -properties memberof).memberof 
    foreach ($group in $currentUserGroups) {        
        $var = New-Object -TypeName psobject -Property @{
            SID = $User.SamAccountName
            Name = $User.Name
            Group = (Get-ADGroup $group).samaccountname
        } | Select-Object SID, Name, Group
        $results += $var
    }
}
$results | Export-Csv -Delimiter '`t' -Encoding Unicode -Path C:\Temp\results.csv