List Distribution Group Membership in Office 365

One of the most common, yet annoyingly difficult, requests we get asked as Exchange admins is to find out what Distribution Groups someone is a member of. Today we’re going to show you a script that can help you with this process.

If you don’t have time to mess around with PowerShell, you can quickly and easily get this information using our Office 365 Management software.

Read more

This script produces a CSV output file that looks something like this:

Distribution Group DisplayName,Distribution Group Email,Member DisplayName, Member Email, Member Type
All Employees,Employees@HoustonShoos.onmicrosoft.com,Alex Darrow,AlexD@HoustonShoos.onmicrosoft.com,UserMailbox
All Employees,Employees@HoustonShoos.onmicrosoft.com,Katie Jordan,KatieJ@HoustonShoos.onmicrosoft.com,UserMailbox
All Employees,Employees@HoustonShoos.onmicrosoft.com,Bob Kelly (TAILSPIN),bobk@tailspintoys.com,MailContact
All Employees,Employees@HoustonShoos.onmicrosoft.com,Brian Johnson (TAILSPIN),BrianJ@HoustonShoos.onmicrosoft.com,UserMailbox
Building 1 Rooms,Building1Rooms2657524@HoustonShoos.onmicrosoft.com,Conf Room Adams,Adams@HoustonShoos.onmicrosoft.com,UserMailbox
Building 2 Rooms,Building2Rooms2658086@HoustonShoos.onmicrosoft.com,Conf Room Rainier,Rainier@HoustonShoos.onmicrosoft.com,UserMailbox
Building 2 Rooms,Building2Rooms2658086@HoustonShoos.onmicrosoft.com,Conf Room Hood,Hood@HoustonShoos.onmicrosoft.com,UserMailbox
Executives,Executives@HoustonShoos.onmicrosoft.com,Denis Dehenne,DenisD@HoustonShoos.onmicrosoft.com,UserMailbox
Executives,Executives@HoustonShoos.onmicrosoft.com,Robin Counts,RobinC@HoustonShoos.onmicrosoft.com,UserMailbox
Finance Team,Finance@HoustonShoos.onmicrosoft.com,Molly Dempsey,MollyD@HoustonShoos.onmicrosoft.com,UserMailbox

The Get-DistributionGroupMembers PowerShell script and instructions are available at the Microsoft Script Repository

You can easily open up this output file in Excel and get the information you want using Filters (Shown in Red).

Filters in Excel

To find out who is in a particular Distribution Group, you can filter on the first two columns.

Filter by Distribution Group

Filter Results

Or if you want to find out which groups a particular user is a member of, you can filter on the Member columns.

Filter by User

Filter by User Results

Related Posts

These other blog posts may be of interest to you:

• Export a list of Mailbox Sizes in Office 365
• Finding Inactive Users in Office 365 – Users that have not logged on for a certain period of time.
• Office 365 Administrator Account Best Practises – Ensure your Office 365 account is secured