Unified group members

Question

Hello

i have users in csv file. i want to get the unified groups to which they are members of. will the below script fetch me the information.

$names= Import-Csv C:\data.csv  
$Result= @()   
$groups= Get-UnifiedGroup -ResultSize Unlimited  
       foreach($UnifiedGroup in $UnifiedGroups){  
           foreach($member in (Get-UnifiedGroupLinks -Resultsize Unlimited $UnifiedGroup.name -LinkType Members)){  
               if ($member.PrimarySMTPaddress -eq $name.name){  
                   $Result1 = New-Object PSObject   
                   $Result1 | Add-Member NoteProperty -Name "User" -Value $name.name  
                   $Result1 | Add-Member NoteProperty -Name "UnifiedGroup" -Value (Get-distributiongroup -Resultsize Unlimited $group.name).PrimarySMTPaddress  
                   $Result += $Result1   
               }  
           }  
       }      
   }  
   $Result | Export-csv -Path C:\temp\output.csv -NoTypeInformation  

Answer 1

Hi @Roger Roger

What about checking this:

$names= Import-Csv C:\test\data.csv  
$Result= @()  
foreach($name in $names){  
$groups= Get-UnifiedGroup -ResultSize Unlimited  
        foreach($UnifiedGroup in $groups){  
            foreach($member in (Get-UnifiedGroupLinks -Resultsize Unlimited $UnifiedGroup.name -LinkType Members)){  
                if ($member.PrimarySMTPaddress -eq $name.User_Principal_Name){  
                    $Result1 = New-Object PSObject   
                    $Result1 | Add-Member NoteProperty -Name "User" -Value $name.User_Principal_Name  
                    $Result1 | Add-Member NoteProperty -Name "UnifiedGroup" -Value (Get-UnifiedGroup -Resultsize Unlimited $UnifiedGroup.name).PrimarySMTPaddress  
                    $Result += $Result1  
                }  
            }  
        }      
}  
  
 $Result | Export-csv -Path C:\test\output.csv -NoTypeInformation  

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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

Hi @Roger Roger

For checking one user in which O365 group you could use the script below:
$UserEmail= "user@keyman .com"
$Mailbox = Get-Mailbox | Where {$.PrimarySmtpAddress -eq $UserEmail}
$Office365GroupsMember = Get-UnifiedGroup | where { (Get-UnifiedGroupLinks $.Alias -LinkType Members | foreach {$_.name}) -contains $mailbox.Alias}
$Office365GroupsMember

I tried your command in my environment cannot work, you may need to modify the variable correctly.

Or you could use the script provided here to meet your requirement:
List All the Distribution Groups a User Is Member of Using PowerShell
Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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 3

I have used the below syntax but i getting blank output. The user is member of few unified groups. on two unified groups i am aware he is member but i am getting blank output.

$names= Import-Csv C:\data.csv  
 $Result= @()   
 $groups= Get-UnifiedGroup -ResultSize Unlimited  
        foreach($UnifiedGroup in $UnifiedGroups){  
            foreach($member in (Get-UnifiedGroupLinks -Resultsize Unlimited $UnifiedGroup.name -LinkType Members)){  
                if ($member.PrimarySMTPaddress -eq $name.name){  
                    $Result1 = New-Object PSObject   
                    $Result1 | Add-Member NoteProperty -Name "User" -Value $name.name  
                    $Result1 | Add-Member NoteProperty -Name "UnifiedGroup" -Value (Get-distributiongroup -Resultsize Unlimited $group.name).PrimarySMTPaddress  
                    $Result += $Result1   
                }  
            }  
    }  
    $Result | Export-csv -Path C:\temp\output.csv -NoTypeInformation