<div dir="ltr" style="text-align: left;"> </p>
<div><span style="mso-ansi-language: EN-GB;">This is very common requirement when creating new users. Its much easier to create bulk user using csv file or excel file rather than creating each user manually. </span></div>
<div><span style="mso-ansi-language: EN-GB;">There are lot of tools available some are free some you have to pay for to achieve that. We have created following script to fulfil our requirements. Please use one which is required according your environment and change where its necessary. </span></div>
<div><span style="mso-ansi-language: EN-GB;">Solution One:</span></div>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt;"><span style="font-family: Cambria; font-size: 12.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: ";Times New Roman";; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Below is powershell script, which will create users in Active directory, please run this powershell script in &#8220;Active Directory Module For Windows PowerShell&#8221;.</span></div>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt;"><span style="font-family: Cambria; font-size: 12.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: ";Times New Roman";; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;"><br /><span style="background-color: white;">Create “users.csv” file </span></span></div>
<p><span style="background-color: white;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt;"></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt;"><span style="background-color: yellow;"><span style="font-family: Cambria; font-size: 12.0pt; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: ";Times New Roman";; mso-bidi-theme-font: minor-bidi; mso-hansi-theme-font: minor-latin;">Import-Csv .users.csv | foreach-object { <br />$userprinicpalname = $_.SamAccountName + &#8220;@{domainname}.com&#8221; <br />New-ADUser -SamAccountName $_.SamAccountName -UserPrincipalName $userprinicpalname -Name $_.name -DisplayName $_.name -GivenName $_.cn -SurName $_.sn -Department $_.Department -Path &#8220;CN=Users,DC=biogen,DC=com&#8221; -AccountPassword (ConvertTo-SecureString &#8220;Power~1;&#8221; -AsPlainText -force) -Enabled $True -PasswordNeverExpires $True –PassThru}</span></span></div>
<div></div>
<div><span style="mso-ansi-language: EN-GB;">Solution Two:</span></div>
<div><span style="mso-ansi-language: EN-GB;">Create Excel sheet called “Users.xls” </span></div>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">Set objExcel = CreateObject(&#8220;Excel.Application&#8221;) Set objWorkbook = objExcel.Workbooks.Open _(&#8220;C:Scriptsusers.xls&#8221;) intRow = 2 </span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">Do Until objExcel.Cells(intRow,1).Value = &#8220;&#8221;<span style="mso-spacerun: yes;"> ; ; ; </span></span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">Set objOU = GetObject(&#8220;ou=Finance, dc=fabrikam, dc=com&#8221;) </span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">Set objUser = objOU.Create _</span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">(&#8220;User&#8221;, &#8220;cn=&#8221; &; objExcel.Cells(intRow, 1).Value)<span style="mso-spacerun: yes;"> ; ; ; ; </span></span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">objUser.sAMAccountName = objExcel.Cells(intRow, 2).Value<span style="mso-spacerun: yes;"> ; ; ; ; </span>objUser.GivenName = objExcel.Cells(intRow, 3).Value<span style="mso-spacerun: yes;"> ; ; ; ; </span></span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">objUser.SN = objExcel.Cells(intRow, 4).Value<span style="mso-spacerun: yes;"> ; ; ; ; </span></span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">objUser.AccountDisabled = FALSE<span style="mso-spacerun: yes;"> ; </span></span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">objUser.SetInfo </span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">intRow = intRow + 1 </span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">Loop </span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div style="margin-bottom: .1pt; margin-left: 0cm; margin-right: 0cm; margin-top: .1pt; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="background-color: yellow;"><span style="font-family: Courier; mso-ansi-language: EN-GB; mso-bidi-font-family: Courier; mso-bidi-font-size: 10.0pt;">objExcel.Quit<span style="mso-spacerun: yes;"> ; </span></span></span></div>
<p><span style="background-color: yellow;"> </span></p>
<div></div>
<div><span style="background-color: white;"><span style="mso-ansi-language: EN-GB;">* Credit to Microsoft MSDN</span></span></div>
</div>

The Cyber Security, Compliance & Cloud
Cyber Security | Digital Transformation | Cloud Computing
