Solved

How to make mass update in AD User detail

Posted on 2016-07-15
3
58 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
3 Comments
 
LVL 17

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

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

Question has a verified solution.

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

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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 …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

685 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