Solved

Bulk Update Active Directory Users Attributes

Posted on 2013-11-18
4
1,164 Views
Last Modified: 2013-11-18
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
Comment
Question by:RubinPostaer
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 37

Accepted Solution

by:
Mahesh earned 300 total points
ID: 39657288
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
 
LVL 53

Assisted Solution

by:Will Szymkowski
Will Szymkowski earned 200 total points
ID: 39657616
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
 

Author Comment

by:RubinPostaer
ID: 39657624
thanks guys! both very good methods of achieving what I'm trying to do.
0
 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39657629
Typo in my script on line 3, it should be foreach ($User in $UserMod) {

Will.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Looping through each DC for most recent LastLogon 24 104
Can i use a GC as a DC? 7 75
Exchange 2010 Global Calendar Permissions 2 54
I'm being stupid with my powershell 2 28
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
A hard and fast method for reducing Active Directory Administrators members.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question