PowerShell: Add Users to AD and Add them in Groups

Question

I have script which is working fine, which creates a new Active Directory user. I need to modify the script to add the user to their security group.

Here is what the contents of my CSV file look like:

Firstname,Lastname,Password,Sam,Group
Alice,Gadbois,azerty+123,a.gadbois,GG1
Quincy,Lagueux,azerty+123,q.lagueux,GG1

and here is my PowerShell script:

$objOU = [ADSI]"LDAP://OU=TestOU,DC=Domain,DC=local";
$dataSource = import-csv -Path "c:\users.csv";

foreach($dataRecord in $datasource) {
    $cn = $dataRecord.FirstName + " " + $dataRecord.LastName
    $sAMAccountName = $dataRecord.Sam
    $givenName = $dataRecord.FirstName
    $Password = $dataRecord.Password
    $sn = $dataRecord.LastName
    $sAMAccountName = $sAMAccountName.ToLower()    
    $displayName = $sn + ", " + $givenName   
    $userPrincipalName = $sAMAccountName + “@domain.local"    
    $objUser = $objOU.Create("user","CN="+$cn)    
    $objUser.Put("sAMAccountName",$sAMAccountName)
    $objUser.Put("userPrincipalName",$userPrincipalName)    
    $objUser.Put("displayName",$displayName)    
    $objUser.Put("givenName",$givenName)    
    $objUser.Put("sn",$sn)    
    $objUser.SetInfo()
    $objUser.psbase.InvokeSet(“AccountDisabled",$false)
    $objUser.SetInfo()
}

I need to add a new command in the script, to add each user to his group.

user189198 · Accepted Answer · 2014-01-14 14:23:27Z

2

Use the ActiveDirectory PowerShell module that's included with the Remote Server Administration Tools (RSAT). It has a command called Add-ADGroupMember.

http://technet.microsoft.com/en-us/library/ee617210.aspx

answered Jan 14, 2014 at 14:23

user189198

Sign up to request clarification or add additional context in comments.

Comments

websch01ar · Accepted Answer · 2014-01-14 15:13:52Z

1

Here you go:

As Trevor said, you need to import the Active Directory module at the top of your script.

Import-module ActiveDirectory

And then within your foreach loop, you can add the Add-ADGroupMember Command.

foreach($dataRecord in $datasource) {
    $cn = $dataRecord.FirstName + " " + $dataRecord.LastName
    $sAMAccountName = $dataRecord.Sam
    $givenName = $dataRecord.FirstName
    $Password = $dataRecord.Password
    $sn = $dataRecord.LastName
    $sAMAccountName = $sAMAccountName.ToLower()    
    $displayName = $sn + ", " + $givenName   
    $userPrincipalName = $sAMAccountName + “@domain.local"    
    $objUser = $objOU.Create("user","CN="+$cn)    
    $objUser.Put("sAMAccountName",$sAMAccountName)
    $objUser.Put("userPrincipalName",$userPrincipalName)    
    $objUser.Put("displayName",$displayName)    
    $objUser.Put("givenName",$givenName)    
    $objUser.Put("sn",$sn)    
    $objUser.SetInfo()
    $objUser.psbase.InvokeSet(“AccountDisabled",$false)
    $objUser.SetInfo()

    Add-ADGroupMember -Identity $dataRecord.Group -Member $sAMAccountName
}

Troubleshooting

Verify that each user has group properly assigned:

$users = Import-Csv "Path_To_File.csv"
$users | % {
    $_.Group
}

edited Jan 14, 2014 at 15:13

answered Jan 14, 2014 at 14:24

websch01ar

2,1232 gold badges13 silver badges22 bronze badges

21 Comments

WildBunch Over a year ago

Thanks, but it doesnt work it add user to group, i need to add group to user. The Cmdles you gave me right now if i use it i will add the same group to all users in my CSV file.

WildBunch Over a year ago

websch01ar are You there ?

websch01ar Over a year ago

My apologies. To make it easier, I have updated my post.

WildBunch Over a year ago

Users are there bu there only members of one groups which is domain users. I need them to be add into diferent groups which are in the csv file. Thanks

websch01ar Over a year ago

Can you look at the data in the CSV file? You are iterating over each record so $dataRecord.Group is distinct for each row. However, if each row has the same value, then it will be the same.

|

Collectives™ on Stack Overflow

PowerShell: Add Users to AD and Add them in Groups

2 Answers 2

Comments

21 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

21 Comments

Your Answer

Sign up or log in

Post as a guest

Related