Share via

looking for exchange acounts that are missing from a distribution group in office365

GRGatlin 1 Reputation point
2022-04-05T19:49:54.17+00:00

I have distribution group that should contain all employees. This group contains distribution groups for individual offices. Sometimes there are missing users. Is there a simple way to find users that are not listed in the main distribution group.

Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
7,503 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Michel de Rooij 1,536 Reputation points MVP
    2022-04-05T21:40:32.057+00:00

    The DG is a static one of Dynamic Distribution Group? The latter case, the set of users can of course vary from the moment of sending to the moment of analysis.
    A static DG, you can perform a comparison of the current members against all expected members, eg get-distributiongroupmember <ID> vs get-mailbox

    1 person found this answer helpful.
    0 comments
  2. Kael Yao-MSFT 37,676 Reputation points Microsoft Vendor
    2022-04-06T05:34:44.367+00:00

    Hi @GRGatlin

    If you are using dynamic distribution groups and an attribute (for example department) as the filters, I suppose you may search for users who have an empty value of this attribute.
    You may connect to Azure AD powershell if you have the required permissions and run a cmdlet like: 

    Get-AzureADUser | Where-Object {$_.Department -eq $null} | Select DisplayName

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.