Deleting ALL existing users from a list of Distribution Lists via powershell , Exhcange 2010

Question

Image of CSV

I have the following csv file ( lets name it del.csv )

I would like exchange to read all "Distribution Lists" on all rows under "column A" And remove ALL members from them.

Please advise this, Thanks.

Simon Li · Accepted Answer · 2018-12-15 03:48:02Z

0

Getting the data of CSV file via PowerShell:

get specific cell value in csv file using powershell

And you could try this "Remove-DistributionGroupMember -Identity "Technical Support" -Member "Jan Dryml" " please see the link :Removing all Members in a Distribution Group

Updated: Remove group directly.

$DGs=Import-Csv C:\Users\<UserName>\Desktop\DGS.csv    
$DGs | foreach {
$Group= $_.Group
IF ($Group) { 
Write-Output $Group
Remove-DistributionGroupMember -Identity $Group
Write-Output "Remove Success."
}

}

Or

$DGs=Import-Csv C:\Users\<UserName>\Desktop\DGS.csv 
$DGs | foreach {
$Group= $_.Group
IF ($Group) { 
Write-Output $Group
$list = Get-DistributionGroupMember -Identity $Group
$list | % {
   Remove-DistributionGroupMember -Identity $Group -Member $_.Name -Confirm:$false
   Write-Output "Remove Success."
   }
}

edited Dec 15, 2018 at 3:48

answered Dec 14, 2018 at 9:39

Simon Li

3232 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sj1986 Over a year ago

Thank you fro your reply, I have been using this : link To add users using the same file. i want to have something similar, to remove all users maybe you have an idea of a script in mind ? Thanks.

sj1986 Over a year ago

Thank you My friend, you saved my a** :)

Collectives™ on Stack Overflow

Deleting ALL existing users from a list of Distribution Lists via powershell , Exhcange 2010

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related