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
Term vs Access = IF [Term Date]>[Date of Report] && [Active?]='Y' THEN 'Y' ELSE ...
C:\Users\kkeller019\AppData\Local\Temp\Engine_173680_d5d4150c6e1c426f9757656cdda456d0_\Engine_92008_65bb8d071be8449f999062e986b00956_.yxdb
ByName
Warning
All
ManualDelayed
Correct Access = IF [Start Date]>"2019-07-30" && IsNull([Access Level]) THEN 'UP...
Correct Access - Descending
Start Date
MM/dd/yyyy
DateTime_Out
Convert Start Date From:
MM/dd/yyyy
Container 33
1-2
3-4
5-6
9-10
7-8
11-12
FirstRow
Warn
Warn
FirstRow
Warn
Warn
FirstRow
Warn
Warn
FirstRow
Warn
Warn
FirstRow
Warn
Warn
FirstRow
Warn
Warn
Value
yyyy-MM-dd hh:mm:ss
DateTime_Out
Convert Value From:
yyyy-MM-dd hh:mm:ss
Value
yyyy-MM-dd
DateTime_Out
Convert Value From:
yyyy-MM-dd
Horizontal
Capstone_Solution