I have attached a sample of our HR data with the users EmployeeID and their Superior (Manager). I am tryoing to update our AD from the information stored in the HR system, but dont kow what is the best and easiest method. Not used Powershell, buthappy to give it a shot.
Is there a way of querying the AD for each user with an EmployeeID, and then Update that employee's information (Title, Location, Manager) The problem I can see is that the employee's manager is also reference by their EmployeeID.
I dont have a problem with extracting a seperate spreadsheet as a lookup, but if not needed would be good. Idea behind this is to be able to run it every few months with the update from HR to keep the AD in order.
Lastly I would like an audit log created with the changes done per user.
I have been told Powershell will let you do it in a few lines, instead of scripting could be pages.
I am not fussed which way, just a reliable method of a regular update.
If there is an article with similar to follow, let me know, but a number of searches have ended up with different methods.
Hope this all make sense, and thanks in advance.