Solved

Bulk Update Active Directory Users Attributes

Posted on 2013-11-18
4
1,223 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
A hard and fast method for reducing Active Directory Administrators members.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Suggested Courses

617 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