从一个导入 csv 将多个用户添加到多个组 [英] Add multiple users to multiple groups from one import csv

问题描述

我有一个包含 2 列的 csv，一列是 AD 组名称，一列是用户帐户名称.我正在尝试读取 csv 并将用户导入到相应的组中.

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.

这是我目前必须要做的.它说两个参数(identity,member) 都是空的，这是没有意义的，因为标头是正确指定的.

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:ScriptsImport Bulk Users into bulk groupsulkgroups3.csv"

Foreach($user in $list){       
    add-adgroupmember -identity $_.Group -member $_.Accountname
}

这是 csv 文件中的内容

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 命令和错误

这是我的脚本、我收到的错误和 csv.

Here is my script, error i receive and csv.

Import-Csv "C:ScriptsImport Bulk Users into bulk groupsulkgroups.csv" | 
ForEach { get-aduser $_.Accountname | add-adgroupmember $_.Group}

推荐答案

改变这个:

add-adgroupmember -identity $_.Group -member $_.Accountname

为此:

add-adgroupmember -identity $user.Group -member (Get-ADUser $user.Accountname)

这篇关于从一个导入 csv 将多个用户添加到多个组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！