In Snow License Manager, users may notice that user records show old “Last Used” dates for applications, even though this data should have been removed by metering history cleanup. At the application level, however, no usage data is displayed.

Symptoms

• Navigating to Users > List All Users > Select a User shows a table of applications with a “Last Used” date.
• Some applications display dates older than the configured metering history retention (for example, more than three years old, even when retention is set to three months).
• Clicking into the application shows no associated users, which correctly reflects that older metering data has already been cleaned up.

This issue occurs because older records remain in the tblcomputerapplicationusers table, even though metering data in tblmetering has been deleted according to the retention policy.

Verification

You can confirm the behavior by checking the SQL database:

• select * from snowlicensemanager.dbo.tblmetering order by lastused asc
  • This should show no old metering records (verify cleanup occurred).
• select * from tblcomputerapplicationusers order by lastused asc
  • This may show old data that is not visible in the application view.