Paul Douglas

Users with terminated supervisor

Discussion created by Paul Douglas Employee on Jan 5, 2017
  • Comment • 0

As part of standard governance practices, user access reviews are often completed by supervisors. One thing to be careful of, is users that are recorded as having a supervisor that has been terminated.

It's also nice to be able to attest to the fact that no one falls into this category.

As such, here is a chart and a report and the necessary SQL queries that you can use in your environment targeting this scenario.

(select distinct 'Users' as Users, count(*) as Total from avuser.T_MASTER_ENTERPRISE_USERS WHERE SUPERVISOR_ID IN (select distinct ID from avuser.T_MASTER_ENTERPRISE_USERS where IS_Terminated = 1))

(select distinct FIRST_NAME, LAST_NAME, SUPERVISOR_ID_NAME from avuser.T_MASTER_ENTERPRISE_USERS WHERE SUPERVISOR_ID IN (select distinct ID from avuser.T_MASTER_ENTERPRISE_USERS where IS_Terminated = 1))

Outcomes