Office 365 monthly report for distribution list members RRS feed

  • Question

  • Hi All,


    How do I generate report for the below;

    1. Report for all Distribution List members
    2. Report for authorized senders to that distribution list


    I am using Office 365. 

    Best Regards,


    Thursday, May 4, 2017 2:40 AM

All replies

  • PowerShell script can be used to list all distribution list with its members. You can below script

    Export Office 365 Distribution List Members using PowerShell

    Script Highlights:

    • Allows you to filter the report result based on group size (i.e., Members count).
    • The script can be executed with MFA enabled account.
    • You can choose to either "Export Members of all Distribution Lists" or pass an input file to "Export members of specific Distribution List" alone. 
    • You can filter the output based on whether the group accepts message from external senders or not.
    • Output can be filtered to list Empty group. i.e., Distribution Group without members
    • Exports the report result to CSV.
    • You can get members count based on Member Type such as User mailbox, Group mailbox, Shared mailbox, Contact, etc.
    • The script is scheduler friendly. i.e., credentials can be passed as a parameter instead of saving inside the script.
    • Above all, script exports output in nicely formatted 2 CSV files: One with detailed information and another with summary information.

    • Proposed as answer by Robert_Luck Friday, May 24, 2019 7:10 AM
    • Edited by Kathy Cooper Friday, May 24, 2019 7:21 AM
    Friday, May 24, 2019 7:03 AM