Security: Write SQL scripts for Audit Reports

[PrabhakarThummalaDOL]

• [x] Write SQL scripts for Audit Reports 1. To generate csv file. 2. To generate the result in data studio.

[PrabhakarThummalaDOL]

Created the following script files:

14cOnline_AuditReport_CSV_ActiveUsers.sql 14cOnline_AuditReport_SQL_ActiveUsers.sql

14cOnline_AuditReport_CSV_DeactivatedAndReactivatedUsers.sql 14cOnline_AuditReport_SQL_DeactivatedAndReactivatedUsers.sql

14cOnline_AuditReport_CSV_DeletedUndeletedUsers.sql 14cOnline_AuditReport_SQL_DeletedUndeletedUsers.sql

14cOnline_AuditReport_CSV_LoginLogoutUsers.sql 14cOnline_AuditReport_SQL_LoginLogoutUsers.sql

14cOnline_AuditReport_CSV_NewUsers.sql 14cOnline_AuditReport_SQL_NewUsers.sql

14cOnline_AuditReport_CSV_UserRoleChanges.sql 14cOnline_AuditReport_SQL_UserRoleChanges.sql

Completed.