A reader left a comment on this post http://msmvps.com/blogs/richardsiddaway/archive/2012/12/09/bulk-modifications-using-set-aduser.aspx
I was asked to show how to use the –Clear parameter.
Using the same CSV file this works:
$users = Import-Csv -Path C:\Scripts\adtest.csv # Loop through CSV and update users if the exist in CVS file 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 }
The difference with clear is that you have to use the proper LDAP attribute name – you can find this using ADSIEdit if you don’t know what it is.