Solved

How to make mass update in AD User detail

Posted on 2016-07-15
3
61 Views
Last Modified: 2016-07-23
I inherited an Active Directory environment that is cluttered with years of junk objects and users.
  • We also have an Office 365 subscription that we use a 3rd party company for federated services.  
  • All/most active users are members of set security group (called "365sync").  
  • When 365 syncs and SharePoint creates it's user profiles, a lot of detail from the AD accounts are incorrect (e.g. Managers, Job Titles, etc.)
  • Current staff are spread out across multiple OUs.
  • I just signed up with a 10-day trial to ManageEngine ADManager Plus

I have a spreadsheet with all current staff members and correct job titles and managers.  

Here's my initial question...
* How do I remove all existing AD user detail and upload the spreadsheet with correct detail?
0
Comment
Question by:WPC479
[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
3 Comments
 
LVL 18

Expert Comment

by:Walter Curtis
ID: 41713772
All of this can be done effectively with PowerShell. Look in to that and you will be glad you did.

Good luck...
0
 
LVL 74

Accepted Solution

by:
Jeffrey Kane - TechSoEasy earned 500 total points
ID: 41714612
ManageEngine has a very specific help file that explains how to do this:
https://www.manageengine.com/products/ad-manager/help/csv-import-management/active-directory-modify-users-csv.html

You don't have to delete the info first because their import should overwrite it all.
0
 

Author Comment

by:WPC479
ID: 41714704
Perfect.  I just started looking around ManageEngine's ADManager and hadn't seen that yet.
Worked great.
0

Featured Post

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Active Directory security has been a hot topic of late, and for good reason. With 90% of the world’s organization using this system to manage access to all parts of their IT infrastructure, knowing how to protect against threats and keep vulnerabil…
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

739 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