Forum Discussion
Solved
Remove bulk users from mail-enabled security group
We have an OU built for Withdrawn students; the accounts are disabled but they still show up in groups they belonged to. We need to be able to remove them from mailing lists. We use a mail-enabled se...
stogiefan My bad, should have been member instead of members.. Try this:
foreach ($user in get-aduser -filter * | where-object DistinguishedName -like '*Withdrawn*') {Remove-DistributionGroupMember -Identity 'Students - All' -member $user.SamAccountName -Confirm:$False -WhatIf }(You don't have to install the module again or connect-exchangeonline again in your session, next session you can connect straight away without installing the module too)
Thank you yet again!!
I am able to connect to exch online but I got this error:
A parameter cannot be found that matches parameter name 'members'.
I am able to connect to exch online but I got this error:
A parameter cannot be found that matches parameter name 'members'.
stogiefan My bad, should have been member instead of members.. Try this:
foreach ($user in get-aduser -filter * | where-object DistinguishedName -like '*Withdrawn*') {Remove-DistributionGroupMember -Identity 'Students - All' -member $user.SamAccountName -Confirm:$False -WhatIf }(You don't have to install the module again or connect-exchangeonline again in your session, next session you can connect straight away without installing the module too)
- I understand, but formatting was difficult and this was easier in this case 😅
- That seems like an expensive (performance wise) way of doing this.
Getting all AD Users and then filtering locally (Where-Object) for using a wildcard search where you can just use the search base to get the users from the Withdrawn container.
Get-ADUser -Filter * -Searchbase "OU=Withdrawn,OU=xxx,DC=xx,DC=xx,DC=xx" - I will and thank you again!
- Nice! No problem, glad this worked out for you! Perhaps following an online training is something for you, PowerShell can help you with some many things and sometimes there's no escaping it 😉 https://www.youtube.com/watch?v=CbAbULaEok4
- YES!! This is it, thank you so much!!
