User Maintenance Script with PowerShell
Througout the years of being a sysadmin I’ve needed to try and keep user information and HR information in sync. One of my previous employers was a university and I have the script I used to keep the Oracle user information and the AD information in sync.
I’ve written this script so many times in the past that I’m sure that I am not the only person that needs this. I’ve obviously changed the university and OU names since the original but the premise is the same. We had students that would change status througout the day, they would drop, enroll, etc. and we would need to create or enable the account, disable the account or change the major. All this was done through Oracle software and had no connection to AD. Our Oracle admins created a script that would export all the changes from the last run into a CSV file and I would pick it up and make the appropriate changes.
The next version was supposed to directly query the database and get us out of the file swapping business, but I left that job before it could happen.