generateSamAccountNames.ps1

# csv to get samAccountNames from
$inputCSVPath = "MOCK_DATA.csv"

# csv to put samAccountNames in
$outputCSVPath = "getSamAccountNames_Data.csv"

# load in csv
$users = Import-Csv -Path $inputCSVPath
$output = @()

foreach ($employee in $users) {
    if (-not $employee.First_Name -or -not $employee.Last_Name){
        Write-Host "Skipping row with missing names." -ForegroundColor Yellow
        continue
    }
    # Handle white spaces and special characters
    $firstName = $employee.First_Name.Trim()
    $lastName = $employee.Last_Name.Trim()
    $cleanFirst = $firstName -replace "[^a-zA-Z0-9]"
    $cleanLast = $lastName -replace "[^a-zA-Z0-9]"
    # convert to SamAccountName
    $baseSamAccountName = ($cleanFirst.Substring(0,1) + $cleanLast).ToLower()

    $escapedFilter = $baseSamAccountName.Replace("'","''")

    try {
        $potentialUsers = Get-ADUser -Filter "SamAccountName -like '$escapedFilter*'" -Properties SamAccountName

        $matchingUsers = $potentialUsers | Where-Object {
            $_.SamAccountName -match "^$($escapedFilter)\d*$"
        }

        $matchedNames = ($matchingUsers | Select-Object -ExpandProperty SamAccountName) -join ';'

        $output += [PSCustomObject]@{
            First_Name = $firstName
            Last_Name = $lastName
            Deparment = $employee.Department
            Title = $employee.Title
            Start_date = $employee.Start_Date
            MatchedSamAccountNames = $matchedNames
        }
    } catch {
        Write-Host "Failed to get $firstName $lastName $($_.Exception.Message)" -ForegroundColor Red
        $output += [PSCustomObject]@{
            First_Name = $firstName
            Last_Name = $lastName
            Department = $employee.Department
            Title = $employee.Title
            Start_Date = $employee.Start_Date
            MatchedSamAccountNames = "Error: $($_.Exception.Message)"
        }
    }
}

$output | Export-Csv -Path $outputCsvPath -NoTypeInformation

Write-Host "SamAccountNames file has been created from $inputCSVPath. "