Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1378
  • Last Modified:

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.
0
RubinPostaer
Asked:
RubinPostaer
  • 2
2 Solutions
 
MaheshArchitectCommented:
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 SzymkowskiSenior 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

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now