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
Term Date
Convert 3 From:
MM/dd/yyyy
Start Date
MM/dd/yyyy
Date Time Out
Convert Start Date From:
MM/dd/yyyy
Warn
,
RecordID
1
Int32
6
0
[RecordID]=2 OR [RecordID]=4 OR [RecordID] = 6 OR [RecordID]=8 OR [RecordID]=10 OR [RecordID]=12
Custom
=
True
fixed
2020-08-13 13:16:37
0
2020-08-13 13:16:37
2020-08-13 13:16:37
[RecordID]=2 OR [RecordID]=4 OR [RecordID] = 6 OR [RecordID]=8 OR [RecordID]=10 ...
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],[Da...
Warning
All
ByName
Correct Access = if [Access Level] = [Requested Access Level] or IsNull([Request...
Correct Access - Descending
Horizontal
Capstone