Command Script to find Distribution Lists/Groups for multiple users

Question

Hi I have a spreadsheet/csv of 300+ users, with their name, SAMaccountname, primarySMTP etc.

I'm looking for a way to run a command against each of these users and list their Group/DL membership on ExchangeOnline.

I know this can be done for a single user, using something like:

Get-Recipient -Filter "Members -eq 'CN=deleted,deleted,OU=deleted.onmicrosoft.com,OU=Microsoft Exchange Hosted Organizations,DC=deleted,DC=PROD,DC=OUTLOOK,DC=COM'"

or

Get-DistributionGroup | where { (Get-DistributionGroupMember $.Name | foreach {$.PrimarySmtpAddress}) -eq "deleted"}|fl DisplayName,GroupType,OrganizationalUnit,PrimarySmtpAddress

But I'm looking for a way to batch this for all 340 users I need to run this against....

Answer 1

If you already have the csv then import/set to $users and you could run something like using the AzureAD module ( or set to Get-DistributionGroupMember using Exo Powershell)

$report = Foreach ($user in $users) {
   $groups = $user | Get-AzureADUserMembership

   # create output objects with username and groups:
   Foreach ($group in $groups) {
     [PSCustomObject][ordered]@{
       UserDisplayName   = $user.DisplayName
       UserPrincipalName = $user.UserPrincipalName
       GroupDisplayName  = $group.DisplayName
 }}}



$report | export-csv groups.csv -NoTypeInformation

Answer 2

Hi. Thank you for your question and reaching out. I’d be more than happy to help you with your query.

You can try this script instead:

$<VariableName> = Get-AddressList -Identity <AddressListIdentity>; Get-Recipient -ResultSize unlimited -RecipientPreviewFilter $<VariableName>.RecipientFilter | select Name,PrimarySmtpAddress,HiddenFromAddressListsEnabled

For more information/reference, please see https://learn.microsoft.com/en-us/exchange/address-books/address-lists/manage-address-lists?source=recommendations

If the reply was helpful, please don’t forget to upvote or accept as answer, thank you.