List of all distribution lists that users is a member of in Exchange onprem Exchang Online

Question

Hi I have to get a list of all distribution lists that users are members of in Exchange onprem and Exchange online. How can this be done via PowerShell? I have 10 users for which i want to pull it

Answer 1

Hi,
Assuming you save the scv file in "c:\temp\name.csv", run the following script in powershell:

   $names= Import-Csv c:\temp\name.csv  
   $Result= @()   
   $groups= Get-DistributionGroup  
   foreach ($name in $names) {  
   foreach($group in $groups){  
   foreach ($member in (Get-DistributionGroupmember $group.name)){  
   if ($member.PrimarySMTPaddress -eq $name.name){  
   $Result1 = New-Object PSObject   
   $Result1 | Add-Member NoteProperty -Name "User" -Value $name.name  
   $Result1 | Add-Member NoteProperty -Name "group" -Value (Get-distributiongroup $group.name).PrimarySMTPaddress  
   $Result += $Result1  
   }}}}  
   $Result|Export-csv -Path c:\temp\result.csv -NoTypeInformation  

It may take some time and the result would be at "c:\temp\result.csv".
Besides, are there any other user types in your csv like mail contact?

---

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

Sure, take a look at this script: https://gallery.technet.microsoft.com/office/Office-365-MemberOf-aec693c9

Answer 3

if i have users in csv file in the below format

users
user1@Company portal .com
user2@Company portal .com

can i use the script in this format.
import.csv c:\input.csv .\DG_MemberOf_inventory.ps1

Answer 4

i have tried your syntax of eric it works fine but i dont get any output in exchange onprem, and in exchange online i am getting errors.

i want to try the technet script of michev. i want to use in the below format but not sure how to use it. in the input.csv i have email addresses in below format
users
user1@Company portal .com
user2@Company portal .com

$FilePath = "C:\input.csv"
Import-CSV $FilePath .\script.ps1 | Export-Csv "C:\output.csv" -notypeinformation