DLs export

Question

Hi All

I have users list in a csv file in the below format. i want to pull all the DLs and unified groups these users are members of. How can i export this information to a csv file. experts guide me on this.

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

Answer 1

Hi,
Assuming you have a csv/txt file like this:

name  
user1  
user2  
administrator  

Run the following script in EMS:

 $names= Import-Csv c:\temp\name.csv  
 $Result= @()   
 $groups= Get-DistributionGroup  
 foreach ($name in $names) {  
 foreach($group in $groups){  
 $members= Get-DistributionGroupmember $group  
 foreach ($member in $members){  
 if ($member.name -eq $name.name){  
 $Result1 = New-Object PSObject   
 $Result1 | Add-Member NoteProperty -Name "User" -Value $name.name  
 $Result1 | Add-Member NoteProperty -Name "group" -Value $group  
 $Result += $Result1  
 }}}}  
 $Result|Export-csv -Path c:\temp\result.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 @Glenn Maxwell ,

Please refer the below link for the similar query,

https://learn.microsoft.com/en-us/answers/questions/105946/user-access-to-distribution-lists-and-unified-grou.html

If the above suggestion helps, please click on "Accept Answer" and upvote it.

Answer 3

i am using exchange hybrid environment, i have few DLs in onprem and few DLs in cloud, when i use this syntax in cloud i am getting error.

WARNING: The object DL1 has been corrupted or isn't compatible with Microsoft support
requirements, and it's in an inconsistent state. The following validation errors happened:
WARNING: The group "DL1" is not managed by any recipient but the MemberJoinRestriction
property is set to "ApprovalRequired".

Cannot process argument transformation on parameter 'Identity'. Cannot convert the "DL2" value of type
"Deserialized.Microsoft.Exchange.Data.Directory.Management.DistributionGroup" to type
"Microsoft.Exchange.Configuration.Tasks.DistributionGroupMemberIdParameter".

• CategoryInfo : InvalidData: (:) [Get-DistributionGroupMember], ParameterBindin...mationException
• FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-DistributionGroupMember
• PSComputerName : outlook.office365.com

How can i export unified groups for the users

Answer 4

i am getting the below warning, i have also used the below syntax.

$Result | -Result size Unlimited Export-csv -Path c:\temp\result.csv -NoTypeInformation

WARNING: By default, only the first 1000 items are returned. Use the ResultSize parameter to specify the number of
items returned. To return all items, specify "-ResultSize Unlimited". Be aware that, depending on the actual number of
items, returning all items can take a long time and consume a large amount of memory. Also, we don't recommend storing
the results in a variable. Instead, pipe the results to another task or script to perform batch changes.

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

Will the above script work in Exchange Online