Update User properties in Active Directory from CSV

 

1. Import-Module ActiveDirectory
3. $USERS = Import-CSV c:\users.csv
5. $USERS | foreach {
7. $empid=$_.employeeid
8. $company=$_.company
9. $title=$_.title
10. $department=$_.department
11. $Division=$_.division
12. $pobox=$_.pobox
13. $city=$_.city
15. Set-ADUSer -Identity $_.samaccountname -Replace @{employeeID=$empid; company=$company; title=$title; department=$department; division=$division; postofficebox=$pobox; l=$City}
16. }

=====================================================================================================

Import-Module ActiveDirectory

$USERS = Import-CSV c:\users.csv

$empid=$USERS.employeeid
$company=$USERS.company
$title=$USERS.title
$department=$USERS.department
$Division=$USERS.division
$pobox=$USERS.pobox
$city=$USERS.city
$acc=$USERS.samaccountname

ForEach ($user in $USERS) {
Get-ADUser -Filter "samaccountname -eq '$Acc'" | Foreach {
Set-ADUser $ -Replace @{title = $title}
Set-ADUser $ -Replace @{company = $company}
Set-ADUser $ -Replace @{department = $department}
Set-ADUser $ -Add @{division = $division}
Set-ADUser $ -Replace @{postOfficeBox = $pobox}
Set-ADUser $ -Replace @{l = $city}
Set-ADUser $_ -Replace @{employeeid = $empid}
}
}