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
Term_
Term_3
MM/dd/yy
DateTime_Out
Convert Term_3 From:
MM/dd/yy
Start Date
MM-dd-yyyy
DateTime_Out
Convert Start Date From:
MM-dd-yyyy
RecordID
1
Int32
6
0
Custom
[RecordID] = 2 OR
[RecordID] = 4 OR
[RecordID] = 6 OR
[RecordID] = 8 OR
[RecordI...
Warn
,
12
yyyy-MM-dd hh:mm:ss
DateTime_Out
Convert 12 From:
yyyy-MM-dd hh:mm:ss
8
yyyy-MM-dd
DateTime_Out
Convert 8 From:
yyyy-MM-dd
Date of Report = DateTimeNow()
Term vs Access = IF DateTimeDiff([Term Date],[Dat...
Warning
All
ByName
Correct Access = If [Access Level] = [Requested Access Level] OR IsNull([Request...
Correct Access - Descending
Horizontal
JSC Capstone