DPAS SCR: 01946

• SCR Number
  01946
• Title
  Logging of SQL Script Executions
• DPAS Module
  Enterprise
• Reporting Organization
  Leidos
• State
  Done
• History
  Submitted 08/29/2023
• Description
  Change Request: Process Improvement

  
  

  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.

   

   

  Completed - Release 2023.3.5

×

×

Welcome to the NEW ELMS Support Site. You may still see some documents or other items still referencing DPAS, but we are working to update our remaining content as soon as possible. Be sure to update your bookmark to https://elmssupport.golearnportal.org.

 

Please note that the URL for the live Production environment has changed due to the ELMS name rebranding process. The new URL for ELMS Production is: https://prod.elms.dla.mil