#requires -RunAsAdministrator # COMPUCARE IT | ACER MALL # 02 - Create location OUs and import approved users from CSV # CSV must be stored locally in a secured folder. Do not put it on the public website. $ErrorActionPreference = 'Stop' Import-Module ActiveDirectory $Domain = Get-ADDomain $BaseDN = $Domain.DistinguishedName $Locations = @( 'Thanjavur','Thanjavur-New-Bus-Stand','Mayiladuthurai','Karaikal', 'Kumbakonam','Tiruvarur','Mannargudi','Nagapattinam','Sirkazhi', 'Vedaranyam','Cuddalore','Chidambaram','Pudukkottai','Aranthangi', 'Trichy','Thiruverumbur' ) $LocationsOU = "OU=Locations,$BaseDN" if (-not (Get-ADOrganizationalUnit -Identity $LocationsOU -ErrorAction SilentlyContinue)) { New-ADOrganizationalUnit -Name 'Locations' -Path $BaseDN -ProtectedFromAccidentalDeletion $true } foreach ($Location in $Locations) { $LocationDN = "OU=$Location,$LocationsOU" if (-not (Get-ADOrganizationalUnit -Identity $LocationDN -ErrorAction SilentlyContinue)) { New-ADOrganizationalUnit -Name $Location -Path $LocationsOU -ProtectedFromAccidentalDeletion $true } foreach ($ChildOU in @('Users','Computers')) { $ChildDN = "OU=$ChildOU,$LocationDN" if (-not (Get-ADOrganizationalUnit -Identity $ChildDN -ErrorAction SilentlyContinue)) { New-ADOrganizationalUnit -Name $ChildOU -Path $LocationDN -ProtectedFromAccidentalDeletion $true } } Write-Host "Verified OU: $Location" -ForegroundColor Green } $CSVPath = 'C:\AcerMallAD\Users.csv' if (-not (Test-Path $CSVPath)) { Write-Host "OU creation complete. No CSV found at $CSVPath; user import skipped." return } $Users = Import-Csv -Path $CSVPath $Required = @('SamAccountName','GivenName','Surname','DisplayName','Location','Department','Title','InitialPassword') $Missing = $Required | Where-Object { $_ -notin $Users[0].PSObject.Properties.Name } if ($Missing) { throw "CSV is missing columns: $($Missing -join ', ')" } foreach ($User in $Users) { $Sam = ([string]$User.SamAccountName).Trim() $Location = ([string]$User.Location).Trim() if ($Location -notin $Locations) { Write-Warning "Invalid location for $Sam"; continue } if ($Sam -notmatch '^[A-Za-z0-9._-]{1,20}$') { Write-Warning "Invalid username: $Sam"; continue } if ([string]::IsNullOrWhiteSpace($User.InitialPassword)) { Write-Warning "Missing initial password for $Sam"; continue } $Existing = Get-ADUser -Filter "SamAccountName -eq '$Sam'" -ErrorAction SilentlyContinue if ($Existing) { Write-Warning "Already exists: $Sam"; continue } $UserOU = "OU=Users,OU=$Location,$LocationsOU" $SecurePassword = ConvertTo-SecureString $User.InitialPassword -AsPlainText -Force try { New-ADUser ` -Name $User.DisplayName ` -GivenName $User.GivenName ` -Surname $User.Surname ` -DisplayName $User.DisplayName ` -SamAccountName $Sam ` -UserPrincipalName "$Sam@$($Domain.DNSRoot)" ` -Department $User.Department ` -Title $User.Title ` -Path $UserOU ` -AccountPassword $SecurePassword ` -Enabled $true ` -ChangePasswordAtLogon $true Write-Host "Created: $Sam ($Location)" -ForegroundColor Green } catch { Write-Warning "Failed: $Sam - $($_.Exception.Message)" } finally { $SecurePassword = $null } } Write-Host 'OU and user provisioning run completed.'