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
Solved

How to make mass update in AD User detail

Posted on 2016-07-15
3
57 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
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…

829 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