POWERSHELL: List DL <> User Memberships (with a one-to-one mapping)

$dist = ForEach ($group in (Get-DistributionGroup -ResultSize Unlimited -Filter {name -like "*"})) 
   { Get-DistributionGroupMember $group -ResultSize Unlimited | Select @{Label="Group";Expression={$Group.Name}},@{Label="User";Expression={$_.Name}},SamAccountName,@{Label="Organizational Unit";Expression={$_.OrganizationalUnit}}  
   }
$dist | Sort Group,User | Export-CSV User2DL_Inventory.csv -NoTypeInformation

No comments:

Post a Comment