KB ID 0001475
Problem
I had to do this a few weeks ago, so I documented it. I had a list of usernames in a CSV file and I needed to bulk-add them to a security group.
Bulk Add Group Users Solution
Firstly you will need the usernames (sAMAccountNames) in .csv format like so, (Note: As a header Im using User-Name.) I’ve saved the file to C:\Temp on my server.
Execute the following commands;
Import-Module ActiveDirectory
Import-Csv -Path “C:\Temp\Users-To-Add.csv” | ForEach-Object {Add-ADGroupMember -Identity “Group-Name” -Member $_.’User-Name’}
And there’s our users;
Bulk Remove Group Users Solution
Use the following command;
Now if we check the group, the users have gone;
Related Articles, References, Credits, or External Links
PowerShell: Bulk Enable / Disable Users
Exchange Bulk Export / Import Mail Contacts
Bulk Export Users From One Domain, and Import Into Another
PowerShell: Add All Members of an OU to a Security Group
21/05/2019
What if i wanted to add users to multiple groups . For example if i had a list of sam account names and they needed to be addedd to multiple groups
22/05/2019
Hi,
Assuming you have Groups in a column called ‘Group’, and Users in a column called ‘User-Name’;
$list = import-csv “C:\Folder\Input-File.csv”
Foreach($user in $list){
add-adgroupmember -identity $user.Group -member (Get-ADUser $user.User-Name)
}
Pete
31/05/2019
I’m trying to do something similar. I have a list of AD groups I would like to remove all users from. I can do them individually, but can’t seem to get the format down to import a txt/cvs list of the groups, and then delete all the users from those groups. Any help would be appreciated.
04/11/2019
I get an error, why is that, ive followed your instructions.
PS C:\temp> Import-Csv -Path “C:\Temp\Users-To-Remove.xlsx” | ForEach-Object {Remove-ADGroupMember -Identity “ESB Admins” -Member $_.’User-Name’ -Confirm:$false}
Remove-ADGroupMember : Cannot validate argument on parameter ‘Members’. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
At line:1 char:119
+ … dmins” -Member $_.’User-Name’ -Confirm:$false}
+ ~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [Remove-ADGroupMember], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.RemoveADGroupMember
Remove-ADGroupMember : Cannot validate argument on parameter ‘Members’. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
At line:1 char:119
+ … dmins” -Member $_.’User-Name’ -Confirm:$false}
+ ~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [Remove-ADGroupMember], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.RemoveADGroupMember
Remove-ADGroupMember : Cannot validate argument on parameter ‘Members’. The argument is null or empty. Provide an argument that is not null or empty, and then try the command again.
At line:1 char:119
+ … dmins” -Member $_.’User-Name’ -Confirm:$false}
+ ~~~~~~~~~~~~~~
+ CategoryInfo : InvalidData: (:) [Remove-ADGroupMember], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.RemoveADGroupMember
04/11/2019
1. Make sure that the users in you CSV are actually in ‘ESB Admins’.
2. Make sure on their user account that they have a SAMAccountName and/or an entry under username.