Fetch DL owner information

Question

Hi All

i have a DL lets say mydl@Company portal .com and it has members, i want to know these members are owners to how many other DLs. i am using the below syntax but i am not getting output

$DL1 = Get-DistributionGroupMember -ResultSize unlimited "MYDL@contoso.com"  
$DLs = Get-DistributionGroup -ResultSize unlimited  
$Results = @()  
  
foreach ($DL1 in $DLs) {  
   if ($DL1.ManagedBy -in $MYDL.name) {$Data += $DL | Select DisplayName,PrimarySMTPAddress,ManagedBy,Description}  
   else {}  
}  
  
$Results | Export-Csv C:\temp\output.csv -NoTypeInformation   

Answer 1

@Roger Roger

There are a lot of errors in it, you could compare with this one:

$DL1S = Get-DistributionGroupMember "MYDL@contoso.com" -ResultSize unlimited   
$DL2S = Get-DistributionGroup -ResultSize unlimited  
$Result = @()  
     
foreach ($DL1 in $DL1S) {  
    foreach($DL2 in $DL2S){          
        if ($Dl2.ManagedBy -contains $DL1.Name){  
            $Result += Get-DistributionGroup $DL2.name | select DisplayName,PrimarySMTPAddress,Notes,managedby  
        }  
    }     
}  
$Result | 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.

---

Answer 2

Try this script

$myDisabledUsers = @()
$date = get-date -format dd-MM-yyyy
$managedSydGroups = Get-ADGroup -Filter * -Properties * -Searchbase "OU=SydExchangeGroups,OU=SydGroups,OU=Sydney,DC=my,DC=biz,DC=org" | where {$_.managedby -ne $null} | select name, managedby
$disabledSydUser = Get-ADUser -Filter * -SearchBase "OU=SydDisabledUsers,OU=SydMisc,OU=Sydney,DC=my,DC=biz,DC=org" | where {$_.enabled -eq $false} | select -ExpandProperty distinguishedname

$disabledOwners = foreach($group in $managedSydGroups)
{
    $managedByString = [string]$group.managedby
    if($disabledSydUser -contains $managedByString)
    {$myDisabledUsers += $group} 
}