Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Update AD users from HR Data using EmployeeID (VBScript or Powershell)

Avatar of Snappa2000
Snappa2000 asked on
Active DirectoryVB ScriptPowershell
22 Comments1 Solution2209 ViewsLast Modified:
Guys,
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.
cheers

employee.xls
ASKER CERTIFIED SOLUTION
Avatar of KenMcF
KenMcFFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 22 Comments.
See Answers