PowerDDG

Action & group

Group name

Alias (optional)

Email address (optional)

Existing group (name, alias, or email)

Recipient filter (text)

How do I get a group's current filter?

Connect: Connect-ExchangeOnline
List your dynamic groups: Get-DynamicDistributionGroup | Select-Object Name,PrimarySmtpAddress
Show one group's filter: (Get-DynamicDistributionGroup 'Group Name').RecipientFilter
Copy the output, paste it below, and click Load into editor.

How do I update a group?

Paste and load the group's current filter (above), or build conditions from scratch.
Switch the action to Update existing filter and enter the group's name.
Run the test command to preview who will match.
Copy and run the generated Set-DynamicDistributionGroup command — it replaces the whole filter, not just part of it.

Membership requirements

Quick add common requirements:

“Contains / starts with / ends with” add the * wildcards for you. Values with apostrophes are escaped automatically.

Generated command

Test the filter first (recommended)

Batch script

Nothing in the batch yet — build or edit a group, then add it. Commands pile up here so you can run them all in one shot.

Full batch — 0 command(s)

Notes

Requires the Exchange Online module: Install-Module ExchangeOnlineManagement, then Connect-ExchangeOnline.
Update existing filter replaces the whole filter — it does not add to it. Build the complete rule set here.
Exchange automatically excludes system mailboxes from every dynamic group; you don't need to filter them out.
Membership is evaluated when mail is sent, so changes to user attributes apply automatically.

Step 1 · Get the data from Exchange

How does this work?

Copy the collector script below and paste it into PowerShell. It connects to Exchange Online and reads every dynamic distribution group (with its rules and current members) and every regular distribution group, including mail-enabled security groups (with its member list). Large tenants can take a few minutes.
When it prints "Done", the data is already on your clipboard — come back here and press Ctrl+V in the box below.
Click Load groups. Step 3 shows every group — tick the ones you want in the report, open Members to see exactly who is included right now, or use Edit to open a group's rules in the Command builder tab — the ⧉ Duplicate as new button there copies whatever is loaded into a fresh group.
In Step 4, fill in the customer name and use Print / save as PDF — the report preview at the bottom shows each group's rules in plain English with its member list, and only the report itself is printed.

Report data collector script

Connect-ExchangeOnline
$report = @()
$report += foreach ($g in Get-DynamicDistributionGroup -ResultSize Unlimited) {
    $members = @(Get-Recipient -RecipientPreviewFilter $g.RecipientFilter -ResultSize Unlimited |
        Select-Object DisplayName,
            @{n='PrimarySmtpAddress';e={"$($_.PrimarySmtpAddress)"}},
            @{n='RecipientTypeDetails';e={"$($_.RecipientTypeDetails)"}})
    [pscustomobject]@{
        Type    = 'Dynamic'
        Name    = $g.Name
        Email   = "$($g.PrimarySmtpAddress)"
        Filter  = "$($g.RecipientFilter)"
        Members = $members
    }
}
$report += foreach ($g in Get-DistributionGroup -ResultSize Unlimited) {
    $members = @(Get-DistributionGroupMember -Identity "$($g.Guid)" -ResultSize Unlimited |
        Select-Object DisplayName,
            @{n='PrimarySmtpAddress';e={"$($_.PrimarySmtpAddress)"}},
            @{n='RecipientTypeDetails';e={"$($_.RecipientTypeDetails)"}})
    [pscustomobject]@{
        Type    = 'Static'
        Name    = $g.Name
        Email   = "$($g.PrimarySmtpAddress)"
        Filter  = ''
        Members = $members
    }
}
ConvertTo-Json -InputObject @($report) -Depth 5 -Compress | Set-Clipboard
Write-Host "Done - the report data is on your clipboard. Paste it into the builder page."

Step 2 · Paste the data & load

Paste the script output here (Ctrl+V)