Powershell to populate the Office attribute for users with the containing OU name

Most companies will name OUs after the offices that users are located in, simple script I wrote to add the containing OU name to the office attribute

$aduser = Get-ADUser -SearchBase ‘The OU you want to do this to’ -Filter *

foreach ($i in $aduser)

{

$distinguishedName = $i.DistinguishedName

$OU = [regex]::match($distinguishedName,'(?=OU)(.*\n?)(?<=.)').Value

$OU = $OU.Substring(3)

$OU = $OU.split(',')[0]

echo " Processing $OU"

Set-ADUser -Identity $i -Office $OU

}

Hope this helps someone :)