🎉 Our Office 365 Reporting Tool is now available in Azure Marketplace 🚀
This website uses cookies to improve your experience. We'll assume you're ok with this. Know more.

How to Get the List of All Dynamic Distribution Groups in Microsoft 365

Dynamic Distribution Groups (DDGs) in Exchange Online are self-updating address books that automatically include members based on job roles or departments, simplifying targeted email communication. However, it is essential to manage these groups carefully to avoid sending confidential information to unintended recipients or missing key announcements due to membership changes. Let's explore effective methods to manage dynamic distribution groups and avoid potential disruptions.

Native Solution

Microsoft 365 Permission Required

High
Least Privilege

View-Only Organization Management Role

Most Privilege

Global Admin

Option 1 Using Exchange Admin Center

  • Sign-in to the Exchange admin center.
  • Navigate to Recipients»Groups to see all the groups in Microsoft 365 environment.
  • Now, click on the Dynamic distribution list to filter only the dynamic distribution groups in Exchange Online.
  • You can click on the Export option to export all dynamic distribution groups in CSV.
Using Exchange Admin Center

Option 2 Using Windows PowerShell

  • Run the below cmdlets to get a list of all dynamic distribution groups using PowerShell.
  • Windows PowerShell Windows PowerShell
     Connect-ExchangeOnline
    
    Get-DynamicDistributionGroup | select Name, PrimarySmtpAddress, ManagedBy
Using Windows PowerShell
  • To export dynamic distribution group members to csv, use the Export function in PowerShell with the file path in the pipeline.

Option 3 Using PowerShell Script

  • Exporting dynamic distribution groups in Exchange admin center is convenient. However, viewing DDL members involves clicking each group individually, which can be tedious when dealing with multiple groups.
  • This is where our PowerShell script helps you in exporting a comprehensive list of dynamic distribution groups and their members in two different CSV files.
  • Preview of dynamic distribution groups csv file
    ps-script-ddl
  • Preview of dynamic distribution group members csv file
    ps-script-ddl-members
AdminDroid Solution
More than 150 reports are under the free edition.

AdminDroid Permission Required

Any user with report access delegated by the Super Admin.

StepsUsing AdminDroid

ad
  • Login to the AdminDroid Office 365 portal.
  • Navigate to the Dynamic Distribution Groups report located under Reports»Exchange»Exchange Groups.
Using AdminDroid

Gain visibility into the complete list of dynamic distribution groups along with the configured dynamic membership filters and the managed by details for each group.

admindroid-chart
  • Visualize dynamic distribution groups with graphical representations that showcase the count of groups managed by each owner.

Struggling to Keep Track of your Dynamic Distribution Groups?

Effectively manage & monitor dynamic distribution groups with AdminDroid Exchange Online reports, and ensure that small changes in membership conditions do not lead to communication chaos within your organization!

Witness the report in action using the

Important Tips

Periodically review the usage of dynamic distribution groups and remove the inactive dynamic distribution groups from your Exchange Online environment.

Configure message approval in dynamic distribution groups to set moderator approval before sending messages, ensuring important communications are reviewed and controlled.

Configure sender options in dynamic distribution lists to allow messages only from your organization, protecting against external malware emails.

Azure ADPrevent Miscommunication with Detailed Monitoring of Dynamic Distribution Groups in Microsoft 365

Showing 1 of 4

How to create a dynamic distribution group in Microsoft 365?

In Microsoft 365, dynamic distribution group members are determined by recipient filters and conditions rather than a static list. These email groups are useful when membership needs to be dynamic and based on specific attributes or criteria. You can reconfigure the settings at any time based on your needs, and the dynamic distribution group will automatically update its membership based on recipient filters.

To create a dynamic distribution group in Exchange Online

  • Navigate to the Groups page in the Exchange admin center.
  • Click on the Add a group.
  • Choose the group type as Dynamic distribution and provide a name & description for the group.
  • Now, set owners for your group and configure the rules that will be used to add recipients to the group.

create-ddg

  • Once configured, click Next to save the rule configurations.
  • In the following page, enter an SMTP email address for the dynamic distribution group.
  • Now, verify the configurations and click the Create group button to create a new dynamic distribution group.

Note: The maximum number of members allowed in a dynamic distribution group is 100,000 users.

The Exchange admin center provides a simplified interface for managing dynamic distribution groups, with a primary focus on "AND" conditions for recipient filters. To use "OR" operator you will need to utilize the PowerShell method.

To create a dynamic distribution group with PowerShell

  • Connect to Exchange Online module using your administrative credentials.
    Connect-ExchangeOnline
  • Create a dynamic distribution group with ‘or’ operator.
    New-DynamicDistributionGroup -Name <GroupName> -RecipientFilter {(Department -eq 'x') -or (Department -eq 'y')}

Note: You can configure various filters, such as department, state, country, or custom attributes in dynamic distribution groups.

Maintain efficient dynamic distribution group management with AdminDroid!

With AdminDroid’s dynamic distribution group changes report, admins can generate detailed reports on activities like group creations, deletions, membership changes, and owner updates, ensuring comprehensive oversight.

  • Utilize AdminDroid's simple filter feature to set Performed Operation to 'New-DynamicDistributionGroup' and retrieve new dynamic distribution groups created recently.
admindroid-simplefilter

That's it! With just a few clicks, you can access a detailed report on new dynamic distribution group creations, including creation time, the user who performed the action, along with recipient filter rules.

How to get dynamic distribution group members?

Although a dynamic distribution group doesn’t have static members like a traditional distribution group, you can retrieve the list of users that currently match the membership conditions configured for the group. It will help you verify the accuracy of the group, ensure targeted communication, and effectively manage group membership.

To get the dynamic distribution group members in Exchange Online, follow the steps below.

  • Navigate to the Groups page in the Exchange admin center.
  • Under the Dynamic distribution groups section, select the group for which you want to get the list of group recipients.
  • Click on the Members column to view all recipients along with the owner of the dynamic distribution group.

By using PowerShell with Exchange admin privilege, you can get the list of all dynamic distribution group members, recipient filter, managed by and other attributes.

  • Connect to the Exchange Online PowerShell module and run the below cmdlet to get the dynamic distribution group owners.
    Get-DynamicDistributionGroup -Identity <GroupName> | Select-Object Name, ManagedBy 
  • Run the below cmdlet to get the dynamic distribution group recipient filter using PowerShell.
    Get-DynamicDistributionGroup -Identity <GroupName> | Select-Object -ExpandProperty RecipientFilter 
  • To view members of dynamic distribution group, run the below cmdlet.
    Get-Recipient -RecipientPreviewFilter (Get-DynamicDistributionGroup -Identity <GroupName>).RecipientFilter 

    Note: Each DDG's membership list will be updated every 24 hours based on configured filters and conditions.

  • To manually force dynamic distribution group to refresh the membership, run the below cmdlet.
    Set-DynamicDistributionGroup -Identity <GroupName> -ForceMembershipRefresh 

Monitor dynamic distribution groups usage with Exchange admin center

Exchange Online dynamic distribution groups usage report allows admins to track the usage count and last accessed time of DDLs based on members' activity within a selected time frame. It also provides a default pie chart for easy visualization of dynamic distribution group data.

  • Login to the Exchange admin center.
  • Navigate to the Dynamic distribution group report residing under Reports»Mail flow.
  • If you wish to view the DDG usage report for a different date range, you shall adjust the report period accordingly.
usage-report-raw

How to manage dynamic distribution groups?

Managing dynamic distribution groups is essential for ensuring accurate message delivery and streamlined team collaboration. To ensure they function optimally, it is crucial to implement best practices for maintaining security and effective communication.

Admins can enhance security by restricting mail senders to dynamic distribution groups, allowing only authorized users to send messages. This measure enhances the group's security by reducing the risk of unauthorized communication and ensuring that only approved users can interact with the group.

To configure users to allow to send messages to the dynamic distribution group, run the below cmdlet after connecting Exchange Online module.

Set-DynamicDistributionGroup –AcceptMessagesOnlyFrom <UserPrincipalName>
#In the pipeline, enter the identity of the dynamic distribution group to authorize the specific user to send emails to the dynamic distribution list.

Additionally, admins can assign Send As or Send on Behalf permissions to trusted users to ensure that the emails are handled correctly, maintaining communication integrity and authority.

  • Run the below cmdlet to configure send as permission for a user in dynamic distribution group.

    Add-RecipientPermission -Identity <GroupEmail> -Trustee <UserPrincipalName> -AccessRights SendAs
    #In the pipeline, you will be asked for confirmation of the process.

  • To configure send on behalf permission for a user in dynamic distribution group, run the below cmdlet.

    Set-Mailbox -Identity <GroupEmail> -GrantSendOnBehalfTo <UserPrincipalName>
    #In the pipeline, you will be asked for confirmation of the process.

Managing dynamic distribution groups involves tracking overall changes within the groups and their memberships. This helps prevent miscommunication and ensures sensitive information reaches only the appropriate users.

To get the dynamic distribution group changes for the last 30 days, use the below cmdlet in the elevated admin PowerShell.

Search-AdminAuditLog -Cmdlets 'New-DynamicDistributionGroup', 'Set-DynamicDistributionGroup', 'Remove-DynamicDistributionGroup' -StartDate (Get-Date).AddDays(-30) -EndDate (Get-Date) | Select-Object RunDate, UserId, CmdletName, ObjectModified, Parameters

Monitor the changes in dynamic distribution group effectively!

Admins can monitor dynamic distribution groups changes using AdminDroid's comprehensive report. This report includes details such as event time, performed operation, user who performed the action, and the dynamic distribution group where the change is performed.

alert-on-changes

By utilizing AdminDroid's advanced alerting feature, you can effortlessly create a Quick Alert that notifies the admins whenever changes occur to a dynamic distribution group.

What is the difference between distribution list and dynamic distribution list?

Distribution lists and dynamic distribution lists are both essential tools in managing email communication within organizations, but they differ in their structure and functionality. Some of the major differences are listed below.

dlvsddl

Overall, managing traditional distribution groups is often tougher than managing dynamic distribution groups, as it requires manual updates each time membership changes.

Is it possible to upgrade the distribution list to a dynamic distribution list?

No, converting a distribution group to a dynamic distribution group is not feasible due to their fundamentally different membership structures and management methods. Dynamic distribution groups rely on recipient filters for dynamic membership, while traditional distribution groups maintain static member lists.

To transition, Microsoft 365 admins must create a new dynamic distribution group with an appropriate recipient filter and manually migrate members to reflect the dynamic criteria, ensuring accurate group functionality.

AdminDroid Exchange Groups ReporterProactively monitor and validate changes in dynamic distribution groups!

AdminDroid's Exchange Online reporting tool provides a intuitive interface that allows you to quickly access and explore Exchange group reports and track group changes, saving valuable time and effort.

Discover an effective approach to handle Exchange groups with AdminDroid!

Dynamic Distribution Groups report provides a comprehensive visualization of all dynamic distribution groups. It also displays the specific dynamic filters applied to each group, offering a clear and detailed overview.

A Quick Summary

Automated DDG Monitoring

AdminDroid's scheduling feature ensures timely delivery of dynamic distribution group insights to designated admins at scheduled intervals.

Prevent Unauthorized DDL creation

Monitor and detect unauthorized Exchange Online management role changes to prevent dynamic distribution group creation by unauthorized users.

Real-time Alerts on the DDL Changes

Utilize AdminDroid’s alerting feature to receive alerts for unusual changes in dynamic distribution groups and address issues promptly before they affect a large number of members.

Comprehensive Reporting on Exchange Online Groups

Efficiently manage Exchange Online groups by leveraging dynamic distribution groups and role group reports to gain complete control of your Exchange Online environment.

Analysis DDG through Data-Driven Charts

Create advanced statistical views with AI-powered graphs to quickly compare attributes and gain an overview of your DDGs.

Streamline Exchange Group Operations

AdminDroid’s rich filtering feature streamlines the monitoring of DDL settings by isolating specific group operations, which enhances efficiency in both management and tracking.

Overall, AdminDroid provides powerful features that empower you to efficiently manage and track dynamic distribution groups for Microsoft 365 admins. By utilizing AdminDroid's advanced reporting and monitoring capabilities, admins can overcome the challenges of managing DDGs, ensuring streamlined communication, and improved oversight.

Kickstart Your Journey with AdminDroid

Your Microsoft 365 Companion with Enormous Reporting Capabilities!

Common Errors and Resolution Steps in Monitoring and Managing Dynamic Distribution Groups

The following are possible errors and troubleshooting hints while dealing with dynamic distribution groups management.

Error: There are no members in my dynamic distribution group.

This error may be due to recent creation or modification in the dynamic distribution group filter.

Troubleshooting hint :Wait for at least 2 hours for dynamic distribution group to refresh. To refresh the dynamic distribution group manually, run the below cmdlet.

Set-DynamicDistributionGroup -Identity <GroupName> -ForceMembershipRefresh

Error: You don't have permission to send to <Dynamic distribution list name>.

This error occurs in Outlook when a user attempts to send an email to a dynamic distribution group that has restrictions on who can send messages to it.

Troubleshooting hint :To resolve this, add the user to the allowed sender list if necessary.

Error: The group <GroupName> only accepts messages from people on its allowed senders list, and your email address isn't on the list.

This error occurs when a user tries to send an email to a dynamic distribution group that only accepts messages from approved senders, and the user email address is not on the list.

Troubleshooting hint :To resolve this, add the required user as an approved mail sender.

Set-DynamicDistributionGroup –AcceptMessagesOnlyFrom <UserPrincipalName>
#You can enter multiple users separated by commas.

Error: Cannot process argument transformation on parameter 'RecipientFilter'.

This error occurs when the provided filter expression is incorrect. Ensure the recipient filter conforms to the expected syntax.

Troubleshooting hint :To resolve this error, verify the filter expression and try again.

Error: Cannot process argument transformation on parameter 'Identity'. Cannot convert the <Group name> value of type "System.String" to type "Microsoft.Exchange.Configuration.Tasks.GroupIdParameter".

This error occurs when the group name specified for the ‘Identity’ parameter is not valid.

Troubleshooting hint :If the group name contains spaces, enclose the group name in double quotation.