none
Exchange Online: Report Who is Authorized to Send to a Distribution List RRS feed

  • Question

  • Hi guys,

    When I try to export the Report Who is Authorized to Send to a Distribution List, I cannot got all the members by run the powershell cmdlet.

    Run the cmdlet Get-DistributionGroup “DL Name” | Select Name,AcceptMessagesOnlyFromSendersOrMembers | out-file E:\dl.txt , there cannot get all the members, but "..." instead.

    Name                                                                             AcceptMessagesOnlyFromSendersOrMembers                                        
    ----                                                                             --------------------------------------                                          
    365 ALL                                                                          {Managing_Distribution_List, Computer, Yellow River, liyuan...}  

    Also I run the cmdlet Get-DistributionGroup “DL Name” | Select Name,AcceptMessagesOnlyFromSendersOrMembers | export-csv E:\dl.csv, there is no separator between the members

    #TYPE Selected.System.Management.Automation.PSCustomObject
    Name AcceptMessagesOnlyFromSendersOrMembers
    365 ALL Managing_Distribution_List Computer Yellow River liyuan SMO-14098ZPJH Sub Business IT Security


    So is there any script to export the whole members of the report, and can easily export all the members?

    Sunday, January 4, 2015 2:25 PM

Answers

  • Get-DistributionGroup “DL Name” |
        Select -expand A
    cceptMessagesOnlyFromSendersOrMembers |
        Out-File <filename> 

    OR

    Get-DistributionGroup “DL Name” |
        Select Name A
    cceptMessagesOnlyFromSendersOrMembers |
        Format-List

    OR

    Write a custom formatter.


    ¯\_(ツ)_/¯

    • Marked as answer by Shootan Wednesday, January 7, 2015 2:08 AM
    Sunday, January 4, 2015 4:01 PM

All replies

  • Hi,

    You can use

    Get-DistributionGroup “DL Name” | Select Name,AcceptMessagesOnlyFromSendersOrMembers | format-list

    to display all users

    /\


    Best Regards,

    Jesper Vindum, Denmark

    Systems Administrator

    Help the forum and vote helpful replies or mark them as answer, if it helps solving your problem.

    Sunday, January 4, 2015 3:09 PM
  • Get-DistributionGroup “DL Name” |
        Select -expand A
    cceptMessagesOnlyFromSendersOrMembers |
        Out-File <filename> 

    OR

    Get-DistributionGroup “DL Name” |
        Select Name A
    cceptMessagesOnlyFromSendersOrMembers |
        Format-List

    OR

    Write a custom formatter.


    ¯\_(ツ)_/¯

    • Marked as answer by Shootan Wednesday, January 7, 2015 2:08 AM
    Sunday, January 4, 2015 4:01 PM
  • Yes, I can get the full list by runnig the cmdlet

    Get-DistributionGroup “DL Name” |  Select -expand AcceptMessagesOnlyFromSendersOrMembers | Out-File <filename>

    Jrv, thanks a lot ! :)



    Wednesday, January 7, 2015 2:08 AM
  • Hi All,

    Correct command to run in Exchange online

    Get-DistributionGroup “DL Name” |  Select -expandProperty AcceptMessagesOnlyFromSendersOrMembers

    Thanks


    Kirpal Singh

    Monday, April 4, 2016 12:27 PM
  • Hi,

    If you use AcceptMessagesOnlyFromSendersOrMembers, you can get a list of users allowed if the attribute is set. If Distribution group allowed to get mail from all internal users or both internal and external users, you will not get a proper allowed senders from   AcceptMessagesOnlyFromSendersOrMembers attribute. In that case, you should consider RequireSenderAuthenticationEnabled attribute.

    You can try this script to Get Distribution Groups' Allowed Senders



    Wednesday, July 17, 2019 1:55 PM