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.

 

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

 

 

 

This change will provide better system performance and availability.

 

Frequency: Daily