Final State - New Hires
Current Users
Capstone Exercise
Final State - Terminations
Terminations
Robert Goulet|Customer Support|7/23/2019
Richard Bobby|Customer Support|7/20/2019
Megan Rapinoe|Training|10/18/2019
Ann Roberts|Customer Support|1/15/2021
New Hires
Mary Guidry
Training
1
7/10/2019
Terrance Delpit
HR
4
7/9/2019
Melvin Breaux
Training
3
8/3/2019
Martin Williams
Customer Support
2
10/30/2019
Joshua Smith
Customer Support
2
9/1/2019
Use what you've learned to audit user access to our computer systems. Compare the "Current Users" report to the "Terminations" report to ensure former employees do not have access. Flag any discrepancies for "REVIEW".
Then compare the "Current Users" report to the "New Hires" report to ensure recently onboarded employees have the appropriate access. If there is a discrepancy, mark it for REVIEW. Flag new hires with a future start date as UPCOMING.
Current Users.yxdb
Current Users.yxdb
Final State - New Hires.yxdb
Final State - New Hires.yxdb
Final State - Terminations.yxdb
Final State - Terminations.yxdb
Name|Department|Term Date
Last
3
MM/dd/yyyy
DateTime_Out
Convert 3 From:
MM/dd/yyyy
Warn
,
Concat_Value
Last
Concat_Value
Date of Access
yyyy-MM-dd
Date of Access
Convert Date of Access From:
yyyy-MM-dd
Term vs Access = if DateTimeDiff([Term Date],[Date of Report],'days') > 0 then '...
Date of Report
yyyy-MM-dd hh:mm:ss
Date of Report
Convert Date of Report From:
yyyy-MM-dd hh:mm:ss
Start Date
MM/dd/yyyy
DateTime_Out
Convert Start Date From:
Custom
Status = if [Access Level] = [Requested Access Level]
OR
IsNull([Requested Acc...
Warning
All
ByName
Correct Access - Descending
Horizontal
Capstone