Description:
DPAS has no automated mechanism to log executions of SQL scripts for release deployments and ad-hoc data changes. This information could roughly be formulated afterwards, but it would be manual and can be error-prone.
Recommended:
Implement enhancements to the system and database deployment procedures that will automatically log release and ad-hoc data change SQL script executions in a new set of database tables.
Mission Critical:
Provides an improved audit trail via the automation and provides additional compliance checks for the SSAE 18.
Benefits:
This capability would be very beneficial to support SSAE audit requirements, as well as provide valuable debugging information to the Leidos team for issue analysis and troubleshooting.
Frequency: Daily
Users:
N/A - Infrastructural enhancements that wouldn't directly affect the users.
Disclaimer | Accessibility