If you need to clear AD attributes you could use this script as a starting point.
Code:
Import-Module ActiveDirectory
$users = Import-Csv -Path C:\Scripts\adtest.csv
foreach ($user in $users) {
# Search in specified OU and Update existing attributes
Get-ADUser -Filter "SamAccountName -eq '$($user.samaccountname)'" -Properties * -SearchBase "cn=Users,DC=manticore,DC=org" |
Set-ADUser -Clear l, physicalDeliveryOfficeName, division
} ... or this one to modify values.
Code:
Import-Module ActiveDirectory
$users = Import-CSV -Path C:\Scripts\adtest.csv
foreach ($user in $users) {
# Search in specified OU and Update existing attributes
Get-ADUser -Filter "SamAccountName -eq '$($user.samaccountname)'" -Properties * -SearchBase "cn=Users,DC=manticore,DC=org" |
Set-ADUser -City $($user.City) -Office $($user.Office) -Division $($user.Division)
} Bulk AD Users is also good.