windows:scripting:bulk_create_users_with_powershell_from_csv_source [Eureka Moment]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Bulk create users with PowerShell from csv source ======
===== The script =====
<code powershell>
Import-Csv -path NewAdUserFromExcel.csv | foreach {
    # -WhatIf
    New-AdUser -name $_.Name -GivenName $_.GivenName -Surname $_.SurName -SamAccountName $_.SamAccountName -UserPrincipalName $_.UserPrincipalName -OtherAttributes @{'mail'=$_.Mail} -Accountpassword (ConvertTo-SecureString -String $_.Password -AsPlainText -Force) -Enabled $true  -path $_.Path -Company $_.Company
    Add-ADGroupMember -Identity "VPN Access group" -Members $_.SamAccountName
    Add-ADGroupMember -Identity "GitAccess" -Members $_.SamAccountName
    Set-ADUser -Identity $_.SamAccountName -PasswordNeverExpires $true
}
</code>

===== Sample CSV file =====
<code>
Name,GivenName,Surname,SamAccountName,UserPrincipalName,Mail,Path,Password,Company
John Smith,John,Smith,jsmith,jsmith@example.com,sohn.smith@example.com,"OU=Department,OU=Users,DC=example,DC=com",c0mpl3xp4$$w0rd,Department
</code>