Exporting DLs AcceptMessagesOnlyFromSendersOrMembers members UPNs

Question

Need help in Exporting EXO DLs AcceptMessagesOnlyFromSendersOrMembers members UPNs

Answer 1

You cannot export those directly, as the output is returned as Display Names only. You can try "matching" those against the corresponding object, but since Display Name is not an unique attribute, you will end up with ambiguous results.

Answer 2

thats a big challenge. Why i need because we are in the process of creating On prem DLs in Cloud. We want to create them exact copy of on prem DLs, any help you can provide here...

Answer 3

You can use command below to get the accept list and convert them to PrimarySmtpAddress:

(Get-DistributionGroup GroupName).AcceptMessagesOnlyFromSendersOrMembers | Get-Recipient | fl Name,PrimarySmtpAddress  

Answer 4

Hi Thanks for your response.
My requirement is as follows:

1. I have DL Alias names in excel sheet in csv file, so want to pipe this file while fetching below details.
2. I want to export DL Alias names, and DL AcceptMessagesOnlyFromSendersOrMembers members list with UPNs.

Ones, i have above details, i can create DLs in Cloud and use this information to update DLs with "Authorised Senders" details.

Thanks.

Answer 5

Firstly, I need to said, Q&A forum doesn't supported write scripts according to needs so far. We could help modify some script which write by your, but don't supported writing script directly. If you have this kind of demand later, you may need to post it in "stack overflow" forum or open a ticket to Microsoft.

Here are a script writing by me which may be useful to you:

$groups = Import-Csv d:/temp/groups.csv  
foreach ($group in $groups){  
    $name = $group.name  
    $temp = (Get-DistributionGroup $name).AcceptMessagesOnlyFromSendersOrMembers | Get-Recipient | select GroupName,Name,PrimarySmtpAddress  
    foreach ($item in $temp) {  
        $item.GroupName = $name      
    }  
    $temp  
}  

1.Prepare a csv file as picture below:

2.Using script below to get detailed information for those group:

If you want to export the result, you could add ">>location" when running this script: