Code Bible

Groups in Exchange Online

3 min read

The following are scripts for working with groups in Microsoft Online.

For a table like the following, use the (One File) scripts

Group nameMembers
[email protected][email protected]; [email protected]
[email protected][email protected]; [email protected]

For one file per group, with just the members of that group, use the (Per Group) scripts

Members
[email protected]
[email protected]

Prerequisites

These commands require the ExchangeOnlineManagement module.

Scripts

Bulk Add members to DL

Use the following commands to add all the listed emails in a CSV to one distribution list. The CSV should have only one column with a list of email addresses.

$Members = Import-CSV Members.csv
Add-DistributionGroupMember -Identity [email protected] -Member $Members

Get All Distribution groups with Members (One File)

$GroupList = Get-DistributionGroup
$GroupsWMembers = @()
 
$GroupsWMembers = ForEach ($Group in $GroupList) {
    $memberList = ''
    $GroupMembers = Get-DistributionGroupMember "$group"
    ForEach($Member in $GroupMembers) {
        If($memberList) {
            $memberList=$memberList + "; " + $Member.PrimarySmtpAddress
        } Else {
            $memberList=$Member.PrimarySmtpAddress
        }
    }
    $Properties = [ordered]@{'GroupName'=$group;'Members'=$memberList}
    New-Object -TypeName PSObject -Property $Properties
}
$GroupsWMembers | Export-CSV "DL-Members.csv" -NoTypeInformation

Get All Shared Mailboxes with Members (One File)

$GroupList = Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited
$GroupsWMembers = @()
 
$GroupsWMembers = ForEach ($Group in $GroupList) {
    $memberList = ''
    $GroupMembers = Get-MailboxPermission -Identity "$group" | ?{($_.IsInherited -eq $False) -and -not ($_.User -match “NT AUTHORITY”)}
    ForEach($Member in $GroupMembers) {
        If($memberList) {
            $memberList=$memberList + "; " + $Member.User
        } Else {
            $memberList=$Member.User
        }
    }
    New-Object -TypeName PSObject -Property @{
        GroupName = $group
        Members = $memberList
    }
}
$GroupsWMembers | Export-CSV "Shared-Members.csv" -NoTypeInformation

Get All Microsoft 365 Groups with Members (One File)

$GroupList = Get-UnifiedGroup
$GroupsWMembers = @()
 
$GroupsWMembers = ForEach ($Group in $GroupList) {
    $memberList = ''
    $GroupMembers = Get-UnifiedGroupLinks -LinkType Member -Identity "$group"
    ForEach($Member in $GroupMembers) {
        If($memberList) {
            $memberList=$memberList + "; " + $Member.PrimarySmtpAddress
        } Else {
            $memberList=$Member.PrimarySmtpAddress
        }
    }
    New-Object -TypeName PSObject -Property @{
        GroupName = $group.DisplayName
        Members = $memberList
    }
}
$GroupsWMembers | Export-CSV "O365-Members.csv" -NoTypeInformation

Get All Distribution Groups with Members (Per Group)

$GroupList = Get-DistributionGroup
 
Foreach($Group In $GroupList) {
    $name = $Group.DisplayName
    Get-DistributionGroupMember $group.PrimarySmtpAddress | Export-csv "$name.csv"
}

Get All Shared Mailboxes with Members (Per Group)

$GroupList = Get-Mailbox -RecipientTypeDetails SharedMailbox -ResultSize:Unlimited
Foreach($Group In $GroupList) {
    $name = $Group.Name
    Get-MailboxPermission -Identity $group.PrimarySmtpAddress | ?{($_.IsInherited -eq $False) -and -not ($_.User -match “NT AUTHORITY”)} | Export-csv "C:\Temp\Client\$name.csv"
}

Get All Microsoft 365 Groups with Members (Per Group)

$GroupList = Get-UnifiedGroup
Foreach($Group In $GroupList) {
    $name = $Group.Name
    Get-UnifiedGroupLinks -LinkType Member -Identity $group.PrimarySmtpAddress | Export-csv "C:\Temp\Client\$name.csv"
}

Exchange Distribution Group Membership Logs

  1. sign in to the Exchange Admin Center.
  2. go to compliance management > auditing.
  3. click run the admin audit log report.
  4. Filter by date and click search

Graph View