I need to create a PowerShell script that fixes several AD accounts in the office field with the new office spelling, all at once, from capital to normal case. I do not need change the normal office spelling for those that are correctly spelled. Using the

Question

I need to create a PowerShell script that fixes several AD accounts in the office field with the new office spelling, all at once, from capital to normal case. I do not need change the normal office spelling for those that are correctly spelled. Using the -replace command or something else.

Answer 1

This is the code submitted by @Erik Moreau ,corrected to update only those users whose spelling and/or capitalization of the "Office" property is not what is desired:

# Define the incorrect and correct office spellings
$incorrectOffice = "vienna, VA"     # should be spelled exactly -- CAPITALIZATION DOESN'T MATTER!
$correctOffice   = "Vienna, VA"     # should be spelled correctly, WITH CORRECT CAPITALIZATION

if ($incorrectOffice -ceq $correctOffice){
    Throw "Spelling and capitalization of both office strings is identical. This is wrong."
}

# Get all AD users with the office capitalized correctly OR incorrectly
# and update the office field
Get-ADUser -filter "Office -eq $incorrectspelling" -Properties Office | 
    Where-Object {$_.Office -cne $correctOffice} |
        ForEach-Object{
            Set-ADUser -Identity $_ -Office $correctOffice
            Write-Host "Updated office field for user: $($_.SamAccountName)"
        }
Write-Host "Office field update completed."

Answer 2

Hi Martin,

if I understand your request correctly, this might be close to what you are looking for:

# Import the Active Directory module
Import-Module ActiveDirectory

# Define the incorrect and correct office spellings
$incorrectOffice = "OFFICEOLD"
$correctOffice = "OfficeNew"

# Get all AD users with the incorrect office spelling
$users = Get-ADUser -Filter {Office -eq $incorrectOffice} -Properties Office

# Loop through each user and update the office field
foreach ($user in $users) {
    Set-ADUser -Identity $user -Office $correctOffice
    Write-Host "Updated office field for user: $($user.SamAccountName)"
}

Write-Host "Office field update completed."