Compact AD user script

CSV scheidingsteken

# Import active directory module for running AD cmdlets
Import-Module activedirectory
  
#Store the data from ADUsers.csv in the $ADUsers variable
$ADUsers = Import-csv C:\Users\Administrator\Desktop\Gebruikers.csv -Delimiter ";"
#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.username
	$Password 	= $User.password
	$Firstname 	= $User.firstname
	$Lastname 	= $User.lastname
	$OU 		= $User.ou #This field refers to the OU the user account is to be created in
    $Department = $User.department
    $Description = $User.description
    $Title = $User.title
	#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 `
            -EmailAddress "$Username@MAiLDoMAIN.com" `
            -UserPrincipalName "$Username@SeverDomain.Local" `
            -Name "$Firstname $Lastname" `
            -GivenName $Firstname `
            -Surname $Lastname `
            -Enabled $True `
            -DisplayName "$Lastname, $Firstname" `
            -Department "$Department" `
            -Description "$Description" `
            -Title "$Title" `
            -Path $OU `
            -AccountPassword (convertto-securestring $Password -AsPlainText -Force) 
	}
}

Gegevens CSV bestand

Username	Password	Firstname	Lastname	OU	Department	Description	Area of law	Title
H.Hallo	Welkom01	Hoi	Hallo	OU=Nieuwe gebruikers,DC=Eigennaam,DC=Local	Secretariat	Receptionist	Copyright	Manager