DPAS SCR: 01997

• SCR Number
  01997
• Title
  Remove PA/M&U User Tracking Logic
• DPAS Module
  Enterprise
• Reporting Organization
  Leidos
• State
  New
• History
  Submitted 03/08/2024
• Description
  Change Request: Process Improvement

  
  

  Description:

  The DPAS Property Accountability (PA) and Maintenance and Utilization (M&U) modules have a database table (DPAS.appsec.user_tracking) and associated stored procedures and application code logic that is used to track user system navigation activity.  However, the table and associated objects have been superseded by other existing features that are implemented system-wide.  The contents of the appsec.user_tracking table are not currently monitored or used in any meaningful way.  Also, this table generates a lot of DML activity in the production environment and appears to be involved in some periods of reduced application performance.  At a minimum, the unnecessary DML activity against this table will generate excessively large transaction log backup files.

   

  Recommended:

  Drop the DPAS.appsec.user_tracking table and any associated database objects.  Remove the application code logic that called these database objects.

   

  Mission Critical:

   

   

  Benefits:

  This change will provide better system performance and availability.

   

  Frequency: Daily

   

  Users:

  N/A - Infrastructural enhancements that wouldn't directly affect the users.