How can I get Owners of a Distribution Group in a CSV, each owner in different row?

Question

Hello there!
I am not clearly a Powershell Expert and I need a way to export the owners of a Distribution Group be exported in this way

Group1 - Owner1
Group1 - Owner2
Group1 - Owner3
Group2 - Owner1
Group2 - Owner2

The only thing I found is a way to separate the users in the ManagedBy array separated by ";", but I can´t find a way to fortmat in the way I want. The problem here is that we are talking about a huge amount of groups and the CSV is to use it in another tool, so the format should be in that way.
If someone could give me a hand, would be great

Thanks!

PS
If someone have something that combines the members and owners in the same CSV and same format alltogether, will save my life :)

Answer 1

@Sergio Furgiuele

Are you using Exchange online?

You could save groups that you want checked into a source file:

Then save the script below into a .PS1 file:

$Data = @()  
$Groups = import-csv c:/temp/groups.csv  
  
foreach ($group in $groups){  
    $value = Get-DistributionGroup $group.Name | select DisplayName,@{Expression=" ";Label="ManagedBy";}  
    $temp = (Get-DistributionGroup $group.Name).ManagedBy      
    foreach ($element in $temp){  
        $value.ManagedBy = $element.tostring()  
        $temp2 = $value |select DisplayName,ManagedBy  
        $data+=$temp2  
        }  
}$data | export-csv c:/temp/Owner.csv -NoTypeInformation  

Run this PS1 file in Exchange online PowerShell. You will could get the output like below:

---

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

Pls try below

$Groups = @'  
Name,ManagedBy,DisplayName  
Group1,"User1;User2;User3","Group 1"  
Group2,"User1;User2","Group 2"  
'@ | ConvertFrom-Csv  
  
  
foreach ($g in $Groups) { foreach ($m in $g.managedBy.split(';')) { $g | select Name, DisplayName, @{n='Manager'; e= {$m}} }  }  
  

Answer 3

How about the following?

$groups = Import-CSV import-filename.csv  
  
foreach ($group in $groups){  
  ForEach ($account in (Get-DistributionGroup $group.Name).ManagedBy) {  
      $props = [ordered]@{                     
      Group = $group   
      ManagedBy = $account  
      DisplayName = (Get-ADUser $account -properties DisplayName).DisplayName}  
      [PSCustomObject]$props  
  }  
} Export-CSV export-filename.csv -NoTypeInformation  

Answer 4

Why always doing useless and sometimes complex script with variables when you can use a SINGLE LINE command?
I freaking hate scripts when not necessary.

Get-DistributionGroup | select name,managedby | Export-csv "c:\temp\ExportDLs.csv" -NoTypeInformation

The end. With that you'll have the file you need (I also needed this and searched to obtain a single line easy command).