Bulk Update Active Directory Users Attributes

I would like to update the "Job Title" and possibly a few other AD attributes for about 500 users. I have the updated data in an MSSQL database that our intranet site uses, but can export to a csv if need be. I'd like to automate something if possible so that it stays up to date.
RubinPostaerAsked:
Who is Participating?
 
MaheshConnect With a Mentor ArchitectCommented:
Use Bulk ADUsers from Wisesoft softwares
Tool is freeware
Also having csv update feature for any bulk user attribute modifications.

http://wisesoft.co.uk/software/bulkadusers/default.aspx
0
 
Will SzymkowskiConnect With a Mentor Senior Solution ArchitectCommented:
If you are using Server 2008 for your DC's I would recommend using powershell for this... Use the below command to update the attributes as needed.

Import-Module activedirectory
$UserMod = import-csv "c:\yourCSVfile.csv"
foreach ($User in $UserMode) {
$User.sAMAccountName
$User.Title
set-aduser -identity $User.sAMAccountName -title $User.title
}

Open in new window


Make sure that your CSV file is constructed in the below format.
sAMAccountName                  Title
jsmith                                          Director
msmyth                                       Marketing Manager

Will.
0
 
RubinPostaerAuthor Commented:
thanks guys! both very good methods of achieving what I'm trying to do.
0
 
Will SzymkowskiSenior Solution ArchitectCommented:
Typo in my script on line 3, it should be foreach ($User in $UserMod) {

Will.
0
All Courses

From novice to tech pro — start learning today.