One step further - PowerShell script to modify multiple users' property in Active Directory
In my previous script, I showed how we can add or modify the user propertites in Active Directory for single user. Now as a by request script, I will go one step further and try to do the samething for multiple users. The trick is you need to have a csv file ready and the import-csv cmdlet.
I have a sample users.csv file and it looks like this:
| DN Telephonenumber |
|
| CN=UserA,OU=X,OU=Y,OU=Z,DC=what,DC=ever,DC=com xxx-yyy-zzz |
|
| CN=UserB,OU=A,OU=B,OU=C,DC=what,DC=ever,DC=com aaa-bbb-ccc |
|
| CN=UserC,OU=L,OU=M,OU=N,DC=what,DC=ever,DC=com lll-mmm-nnn |
|
Once you have the csv file ready – you could run the below script against it (You need to have the approriate right to your domain!)
$users = import-csv users.csv
foreach($row in $users)
{
$dn = $row.dn
$user=[ADSI]"LDAP://$dn"
$tel = $row.telephonenumber
$user.put("telephoneNumber", $tel)
$user.SetInfo()
}
You could change the Telephonenumber to EmployeeID or whatever fields you are interested at and it can target as many users as you want. Of course, test it in a small scale first!