Solved

Bulk Update Active Directory Users Attributes

Posted on 2013-11-18
4
1,068 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
  • 2
4 Comments
 
LVL 35

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

[b]Ok so now I will show you how to add a user name to the description at login. [/b] First connect to your DC (Domain Controller / Active Directory Server) SET PERMISSIONS FOR SCRIPT TO UPDATE COMPUTER DESCRIPTION TO USERNAME 1. Open Active …
Mapping Drives using Group policy preferences Are you still using old scripts to map your network drives if so this article will show you how to get away for old scripts and move toward Group Policy Preference for mapping them. First things f…
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

863 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now