Add Users to AD Groups

stephanus · 2018-09-07T17:02:34.000Z


User List	Select ALL the department shares the user have access to
user1	Administration, Behavioral, Admissions
user2	Dietary, Education
user3	IT
user4	Marketing, Reception

I have a spreadsheet with the above information and I am trying to figure out a way with powershell to cycle through the list of users and add each one to the group on the right.

I am very green with powershell and any help would be greatly appreciated.

Thanks,

Stephanus

Neally · 2018-09-07T17:07:16.000Z

What have you tried so far ? where are you stuck?

I assume the spreadsheet is a CSV?

foreach($line in (import-csv "c:\folder\file.csv")){
    #do something
}

if it is in excel format (xlsx) you might want to convert it, or look into Doug Finke’s ImportExcel Module

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

mcl2 · 2018-09-07T17:20:31.000Z

I would change the format to CSV and then do something like below.

(“UserName”, “Group1” , etc. are the column header names in your CSV.)

## Import user information from the .csv sheet & define variables:
Import-Module ActiveDirectory
Import-Csv ".\users.csv" | ForEach-Object {
$uname = $_."UserName"
$group1 = $_."Group1"
$group2 = $_."Group2"
$group3 = $_."Group3"
## Add user to Group1
Add-ADGroupMember -Identity $group1 -Member $uname
## Add user to Group2
Add-ADGroupMember -Identity $group2 -Member $uname
## Add user to Group3
Add-ADGroupMember -Identity $group3 -Member $uname
}

stephanosconstantinou · 2018-09-07T19:24:38.000Z

I think this code will help you. Sorry if there are any mistakes. I’m on mobile device.

Thanks
Stephanos

Import-Module ActiveDitectory
$data = Import-Csv "csv-file-path"
foreach ($record in $data){
    [string[]]$groups = $record.groups -split ','
    foreach ($group in $groups){
        Add-ADGroupMember -Identity $group Member $record.user}}

stephanus · 2018-09-11T16:48:53.000Z

Stephanos,

That worked great. The only challenge i face is that i need to relate the departments to the group. I was thinking of doing something like this:

$group = @{
    'admin' = 'mlr_admin_rw'
    'IT' = 'mlr_IT_rw'
    'Copy' = 'mlr_Copy_rw'}

so if the user have access to the admin department share this they belong to the mlr_admin_rw group. It would be nice to do this through PowerShell otherwise i can probably to the conversion with an excel macro. Thanks for all the help so far.

Stephanus

stephanus · 2018-09-11T18:16:36.000Z

Thanks all, I got it figured out.


```
$source = import-csv C:\temp\user-grouptest.csv
$crosswalk = @{
    Accounting = 'Accounting_RO'
    Admissions = 'Admissions_RO'
    IT = 'IT_RO'}

foreach ($record in $source){
    $groups = $record.group -split ', '
    foreach ($group in $groups) {
        add-adgroupmember -identity $crosswalk[$group] -Members $record.user}}
```

<\/th>\n	<\/th>\n<\/tr>\n<\/thead>\n
User List<\/td>\n	Select ALL the department shares the user have access to<\/td>\n<\/tr>\n
user1<\/td>\n	Administration, Behavioral, Admissions<\/td>\n<\/tr>\n
user2<\/td>\n	Dietary, Education<\/td>\n<\/tr>\n
user3<\/td>\n	IT<\/td>\n<\/tr>\n
user4<\/td>\n	Marketing, Reception<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div> I have a spreadsheet with the above information and I am trying to figure out a way with powershell to cycle through the list of users and add each one to the group on the right.<\/p>\n I am very green with powershell and any help would be greatly appreciated.<\/p>\n Thanks,<\/p>\n Stephanus<\/p>","upvoteCount":2,"datePublished":"2018-09-07T17:02:34.000Z","url":"https://community.spiceworks.com/t/add-users-to-ad-groups/672064/1","author":{"@type":"Person","name":"stephanus","url":"https://community.spiceworks.com/u/stephanus"}},{"@type":"Answer","text":" What have you tried so far ? where are you stuck?<\/p>\n I assume the spreadsheet is a CSV?<\/p>\n foreach($line in (import-csv \"c:\\folder\\file.csv\")){\n #do something\n}\n<\/code><\/pre>\nif it is in excel format (xlsx) you might want to convert it, or look into Doug Finke’s ImportExcel Module<\/a><\/p>\n If you post code, please use the ‘Insert Code’ button. Please and thank you!<\/p> \n \n <\/div>\n \n PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum!<\/a> Programming & Development<\/span><\/span><\/a>\n <\/div>\n \n Hi, and welcome to the PowerShell forum! \n\n\nDon’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask!\nUse a descriptive subject. Don't say \"Need help\" or \"PowerShell Help\", actually summarize what the problem is. It helps the rest of us keep track of which problem is which.\nDon’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…\n <\/blockquote>\n<\/aside>\n\n<\/p>","upvoteCount":1,"datePublished":"2018-09-07T17:07:16.000Z","url":"https://community.spiceworks.com/t/add-users-to-ad-groups/672064/2","author":{"@type":"Person","name":"Neally","url":"https://community.spiceworks.com/u/Neally"}},{"@type":"Answer","text":" I would change the format to CSV and then do something like below.<\/p>\n (“UserName”, “Group1” , etc. are the column header names in your CSV.)<\/p>\n ## Import user information from the .csv sheet & define variables:\nImport-Module ActiveDirectory\nImport-Csv \".\\users.csv\" \| ForEach-Object {\n$uname = $_.\"UserName\"\n$group1 = $_.\"Group1\"\n$group2 = $_.\"Group2\"\n$group3 = $_.\"Group3\"\n## Add user to Group1\nAdd-ADGroupMember -Identity $group1 -Member $uname\n## Add user to Group2\nAdd-ADGroupMember -Identity $group2 -Member $uname\n## Add user to Group3\nAdd-ADGroupMember -Identity $group3 -Member $uname\n}\n<\/code><\/pre>","upvoteCount":0,"datePublished":"2018-09-07T17:20:31.000Z","url":"https://community.spiceworks.com/t/add-users-to-ad-groups/672064/3","author":{"@type":"Person","name":"mcl2","url":"https://community.spiceworks.com/u/mcl2"}},{"@type":"Answer","text":"Stephanos,<\/p>\n That worked great. The only challenge i face is that i need to relate the departments to the group. I was thinking of doing something like this:<\/p>\n $group = @{\n 'admin' = 'mlr_admin_rw'\n 'IT' = 'mlr_IT_rw'\n 'Copy' = 'mlr_Copy_rw'}\n<\/code><\/pre>\nso if the user have access to the admin department share this they belong to the mlr_admin_rw group. It would be nice to do this through PowerShell otherwise i can probably to the conversion with an excel macro. Thanks for all the help so far.<\/p>\n Stephanus<\/p>","upvoteCount":1,"datePublished":"2018-09-11T16:48:53.000Z","url":"https://community.spiceworks.com/t/add-users-to-ad-groups/672064/5","author":{"@type":"Person","name":"stephanus","url":"https://community.spiceworks.com/u/stephanus"}},{"@type":"Answer","text":" Thanks all, I got it figured out.<\/p>\n \n```\n$source = import-csv C:\\temp\\user-grouptest.csv\n$crosswalk = @{\n Accounting = 'Accounting_RO'\n Admissions = 'Admissions_RO'\n IT = 'IT_RO'}\n\nforeach ($record in $source){\n $groups = $record.group -split ', '\n foreach ($group in $groups) {\n add-adgroupmember -identity $crosswalk[$group] -Members $record.user}}\n```\n\n<\/code><\/pre>","upvoteCount":1,"datePublished":"2018-09-11T18:16:36.000Z","url":"https://community.spiceworks.com/t/add-users-to-ad-groups/672064/6","author":{"@type":"Person","name":"stephanus","url":"https://community.spiceworks.com/u/stephanus"}}]}}