Bulkuser creation in AD using powershell

Question

I am trying to upload bulk users to my AD using the code below. But it keep giving me an error.

import-csv C:\Users\Administrator\Desktop\properties1.csv |ForEach-Object {New-ADUser -path "OU=Users,OU=ICTLAB,DC=gdgshj,DC=com" -UserPrincipalName $_.UserPrincipalName -SamAccountName $_.SamAccountName -GivenName $_.GivenName -Name $_.Name -DisplayName $_.DisplayName -profilepath $_.Profilepath Set-ADAccountPassword -Identity $_.SamAccountName -Reset -NewPassword (ConvertTo-SecureString -AsPlainText $_.Password -Force) Enable-ADAccount -Identity $_.SamAccountName }

The error is as attached.

Mathias R. Jessen · Accepted Answer · 2016-09-25 15:00:59Z

3

You need a statement terminator for the New-ADUser cmdlet, before calling Set-ADAccountPassword.

You can either use ;, or place Set-ADAccountPassword on a separate line:

Import-Csv C:\Users\Administrator\Desktop\properties1.csv |ForEach-Object {
    New-ADUser -path "OU=Users,OU=ICTLAB,DC=gdgshj,DC=com" -UserPrincipalName $_.UserPrincipalName -SamAccountName $_.SamAccountName -GivenName $_.GivenName -Name $_.Name -DisplayName $_.DisplayName -profilepath $_.Profilepath 
    Set-ADAccountPassword -Identity $_.SamAccountName -Reset -NewPassword (ConvertTo-SecureString -AsPlainText $_.Password -Force) 
    Enable-ADAccount -Identity $_.SamAccountName 
}

You can also chain the commands together in a single pipeline, if you use the -PassThru switch on New-ADUser and Set-ADAccountPassword (notice the | at the end of each line):

Import-Csv C:\Users\Administrator\Desktop\properties1.csv |ForEach-Object {
    New-ADUser -path "OU=Users,OU=ICTLAB,DC=gdgshj,DC=com" -UserPrincipalName $_.UserPrincipalName -SamAccountName $_.SamAccountName -GivenName $_.GivenName -Name $_.Name -DisplayName $_.DisplayName -profilepath $_.Profilepath -PassThru |
    Set-ADAccountPassword -Reset -NewPassword (ConvertTo-SecureString -AsPlainText $_.Password -Force) -PassThru | 
    Enable-ADAccount
}

answered Sep 25, 2016 at 15:00

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

1 Comment

josh Over a year ago

I also need to add the domain name after the USER LOGON NAME '@gdgshj.com' I would also like to Enable, PASSWORD NEVER EXPIRES and USER CANNOT CHANGE PASSWORD options under the account tab. How do I add those codes to this powershell script.

Collectives™ on Stack Overflow

Bulkuser creation in AD using powershell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related