I have a csv with 2 columns, one column is AD group names and one is user account names. I am trying to read the csv and import the users into their corresponding group.
Here is what i have to so far. It's saying both arguments(identity,member) are null, which makes no sense since the headers are correctly specified.
import-module activedirectory
$list = import-csv "C:\Scripts\Import Bulk Users into bulk groups\bulkgroups3.csv"
Foreach($user in $list){
add-adgroupmember -identity $_.Group -member $_.Accountname
}
Heres whats in the csv file
Group Accountname
group1 user1
group1 user2
group1 user3
group2 user4
group2 user5
group3 user6
group3 user7
group3 user8
group4 user9
group5 user10
EDIT Command and error
Here is my script, error i receive and csv.
Import-Csv "C:\Scripts\Import Bulk Users into bulk groups\bulkgroups.csv" |
ForEach { get-aduser $_.Accountname | add-adgroupmember $_.Group}
Change this:
add-adgroupmember -identity $_.Group -member $_.Accountname
To this:
add-adgroupmember -identity $user.Group -member (Get-ADUser $user.Accountname)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With