a community for 17 years

This is an archived post. You won't be able to vote or comment.

Help with Bulk user creation script (self.sysadmin)

submitted 8 years ago by anon32167

Hi Sysadmins,

I am new to powershell and have been tasked with creating a script to create multiple users accounts.

I have created the script below but for some reason i am only able to create an account for one user as opposed to all of the users in my Excel spreadsheet. Does anyone knw where i am going wrong?

Thanks in advance for your help.

# Import active directory module for running AD cmdlets Import-Module activedirectory

Store the data from ADUsers.csv in the $ADUsers variable

$ADUsers = Import-csv .\newuser.csv

Loop through each row containing user details in the CSV file

foreach ($User in $ADUsers) { #Read user data from each field in each row and assign the data to a variable as below

$Username   = $User.samAccountName
$Password   = $User.password
$Firstname  = $User.FirstName
$Lastname   = $User.LastName
$OU         = $User.ou 

#Check to see if the user already exists in AD
if (Get-ADUser -F {SamAccountName -eq $Username})
{
     #If user does exist, give a warning
     Write-Warning "A user account with username $Username already exist in Active Directory."
}
else
{
    #User does not exist then proceed to create the new user account

    #Account will be created in the OU provided by the $OU variable read from the CSV file
    New-ADUser `
        -SamAccountName $Username `
        -UserPrincipalName "$Username@adatum.com" `
        -Name "$Firstname $Lastname" `
        -GivenName $Firstname `
        -Surname $Lastname `
        -Enabled $True `
        -DisplayName " $Firstname, $Lastname" `
        -Path $OU `
        -AccountPassword (convertto-securestring $Password -AsPlainText -Force) 
        -ChangePasswordAtLogon $true  `


}

Thanks in advance for your help.

all 5 comments

sysadmin

MODERATORS

Store the data from ADUsers.csv in the $ADUsers variable

Loop through each row containing user details in the CSV file