#Add-PSSnapin Quest.ActiveRoles.ADManagement #Read in the CSV file Import-Csv -Path "C:\ftp.csv" | ForEach-Object { $FirstName = $_.FName #$LastName = $_.SName $DisplayName = $_.ActualDisplayName $Password = $_.Password $School = $_.School $PrincipalName = $_."E-Mail" $Name = $_.Alias $Alias = $_.Alias $OU = "stockport.sch.uk/schools/" + $School + "/Users" $secureString = ConvertTo-SecureString $Password -AsPlainText –Force # create new users Write-host "Creating User..."#-Title "student" -LastName $LastName to be added in when creating students New-QADUser -FirstName $FirstName -SamAccountName $Alias -Email $PrincipalName -Name $Name -DisplayName $DisplayName -OrganizationalUnit $OU -UserPrincipalName $PrincipalName Set-User -Identity $Alias -DomainController "schdc2" -ResetPasswordOnNextLogon $true }