## Import af CSV fil og defination af i som bruges til at give et total antal
$Users = Import-Csv -path 'C:\PowershellTEST\Userlist - 1000 brugere.csv'
$i = 1

## Foreach loop som definere hvert row og bruger dataen til at oprette en ADUser
foreach ( $row in $Users ) {

$count = $i++
write-host 'User-Number:'$count
write-output $row

$Username = $row.Username
$Displayname = ($row.first_name) + " " + ($row.last_name)
$First_name = $row.first_name
$Last_name = $row.last_name
$email = $row.email
$Gender = $row.gender
$password = $row.password
$company = $row.Company
$country = $row.Country
$Phone = $row.Phone
$Mobile = $row.Mobile
$Department = $row.Department

New-ADUser `
-SamAccountName $Username `
-DisplayName $Displayname `
-GivenName $First_name `
-Surname $Last_name `
-Name $Displayname `
-EmailAddress $email `
-AccountPassword (ConvertTo-SecureString "$password" -AsPlainText -Force) `
-Company $company `
-Country $country `
-HomePhone $Phone `
-MobilePhone $Mobile `
-Department $Department `
-ChangePasswordAtLogon $true `
-UserPrincipalName $Username `
-Enabled $true `
-Path "ou=CSV, DC=o7, DC=lan"}

## Remove all users:
foreach ( $row in $Users ) {
Remove-ADUser -Identity $row.Username -Confirm:$false}

## Check total amount of users in CSV OU
(Get-ADUser -Filter * -SearchBase "ou=CSV, DC=o7, DC=lan").count