Fetch DL Information

Question

Hi All

i am using exchange 2016 hybrid environment. I have DLs created in onprem and online, I also have office365 unified groups. All my users are created in exchange onprem and they are migrated to cloud. i have a 100 users in CSV file and i want to know , are they owners of any DL either it be onprem, online or unified groups. i want to try something like this but not sure.
experts guide me.

My csv file is in the below format.

Name
user1@Company portal .com
user2@Company portal .com

$musers=import-csv "C:\temp\userlist.csv "  
$musers.Count  
$mgroups = @()  
Get-UnifiedGroup -ResultSize Unlimited |  
foreach-object {  
$dgroup=$_  
foreach($user in $musers) {  
if($dgroup.ManagedBy -contains $user.Name) {  
$mgroups += $dgroup  
$mgroups.Count }}}  
$mgroups | Select-Object DisplayName,PrimarySMTPAddress,Notes,@{label="ManagedBy";expression={[string]($_.managedby | foreach {$_.tostring() + ","})}} | Export-Csv "c:\temp\unifiedgroups.csv" -NoTypeInformation  
--------------------------------------------------------------------  
$musers=import-csv "C:\temp\userlist.csv "  
$musers.Count  
$mgroups = @()  
Get-DistributionGroup -ResultSize Unlimited |  
foreach-object {  
$dgroup=$_  
foreach($user in $musers) {  
if($dgroup.ManagedBy -contains $user.Name) {  
$mgroups += $dgroup  
$mgroups.Count }}}  
$mgroups | Select-Object DisplayName,PrimarySMTPAddress,Notes,@{label="ManagedBy";expression={[string]($_.managedby | foreach {$_.tostring() + ","})}} | Export-Csv "c:\temp\DistributionLists.csv" -NoTypeInformation  

Answer 1

@Glenn Maxwell

For Office 365, you could use the script below to check it:

$musers = import-csv "C:\temp\userlist.csv"  
$groups = Get-UnifiedGroup -ResultSize Unlimited  
$Data = @()  
  
foreach ($muser in $musers) {  
    foreach($group in $groups){          
        if ($group.ManagedBy -contains (Get-Mailbox $muser.Name).Name){  
            $Data += Get-UnifiedGroup $group.name | select DisplayName,PrimarySMTPAddress,Notes,managedby  
        }  
    }     
}  
$Data | Export-Csv C:\temp\unifiedgroups.csv -NoTypeInformation  

For distribution group, you could use the script below to check:

$musers = import-csv "C:\temp\userlist.csv"  
$groups = Get-DistributionGroup -ResultSize Unlimited  
$Data = @()  
  
foreach ($muser in $musers) {  
    foreach($group in $groups){          
        if ($group.ManagedBy -contains (Get-Mailbox $muser.Name).Name){  
            $Data += Get-DistributionGroup $group.name | select DisplayName,PrimarySMTPAddress,Notes,managedby  
        }  
    }     
}  
$Data | Export-Csv c:\temp\DistributionLists.csv -NoTypeInformation  

---

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.

---