psu-libraries / fams_tools

Faculty Activity Management Services Tools
MIT License
0 stars 0 forks source link

LDAP Check #37

Open Smullz622 opened 1 year ago

nmg110 commented 1 year ago

Every now and then we need to check the status of accounts in Activity Insight, we download the list of active users that are staff and faculty. We have the ability to cross check most faculty from a report pulled from Workday, but we are finding that we have to cross check faculty and staff at http://www.work.psu.edu/ldap/ because the faculty may not be appearing in our list. Sometimes the number of faculty/staff we need to double check can be 200 or more and as you can imagine that would take us a lot of time.

What I would like to do is to upload a csv file that contains First Name, Last Name, and PSU Access ID to the FAMS Tool, and it check "ldap" and then update the file we uploaded with the following fields: EduPerson Primary Affiliation Title Business Area Department Campus

I will then use these results to disable or enable faculty accounts. Eventually, I would like to build off of this process so it automatically disables the accounts where the LDAP information comes back with EduPerson Primary Affiliation with "Member" or comes back with the user cannot be found.