Forum Discussion
Denise Child
Jul 21, 2022Iron Contributor
bulk replace or clear two attributes in Active Directory - (Info and ipPhone)
Hello, We need to replace or clear two attributes in Active Directory for many people. Those attributes are "info" and "ipPhone". I can use -Clear on an individual user, but am unable to fin...
- Jul 21, 2022
This is the code
$x=import-csv C:\Users\f.malaeb\test1.cvs #Clear $x.ForEach({Set-ADUser $_.sAMAccountName -Clear Info,ipphone}) #Replace $x.ForEach({Set-ADUser $_.sAMAccountName -Replace @{info=$_.info;ipPhone=$_.ipPhone}})
farismalaeb
Jul 21, 2022Steel Contributor
This is the code
$x=import-csv C:\Users\f.malaeb\test1.cvs
#Clear
$x.ForEach({Set-ADUser $_.sAMAccountName -Clear Info,ipphone})
#Replace
$x.ForEach({Set-ADUser $_.sAMAccountName -Replace @{info=$_.info;ipPhone=$_.ipPhone}})
- Denise ChildJul 21, 2022Iron ContributorThank you for the quick response farismalaeb
This helps a lot...I was struggling on how to write this.
I updated the code since the Replace gave an error.
This one works even though it still throws an error.
#Replace
$x.ForEach({Set-ADUser $_.sAMAccountName -Replace @{info=$_.info;};@{ipPhone=$_.ipPhone}})
Some of my test users had the fields blank and others were filled out. Probably needs error checking?
Here is the error message:
Set-ADUser : replace
At C:\Temp\ADUser_Info_ipPhone_change.ps1:6 char:13
+ $x.ForEach({Set-ADUser $_.sAMAccountName -Replace @{info=$_.info;};@{ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (dc:ADUser) [Set-ADUser], ADInvalidOperationException
+ FullyQualifiedErrorId : ActiveDirectoryServer:0,Microsoft.ActiveDirectory.Management.Commands.SetADUser- farismalaebJul 21, 2022Steel ContributorCan you tell if the error for users with blank fields or not.
I my test I had 2 users only- Denise ChildJul 22, 2022Iron ContributorYes, if I have nothing in Notes (info) I get the error. If I am simply replacing text in Notes, no error.
Since we only want to clear iPPhone I updated that part line to remove Info.