ACC / SAM - Staging table records for software usage are being marked as empty - Known Error

ACC / SAM - Staging table records for software usage are being marked as empty Description Empty Records being created in the staging table for software usage This is caused due the software for which that record was created was not discovered for subsequent discovery. The record becomes stale and there's no immediate cleanup for such records

Steps to Reproduce

Configure SAM advance metering for an endpoint Fetch SAM metering for a software and let it create a record in software usage Uninstall the software from the device. Retrigger discovery again Notice that there's a stale record created in software usage table Workaround Attached changes needed for Staging table cleanup. This contains:

Cascade delete for staging table Schedule job to cleanup stale records in staging table.

Note that this would be needed for ACC-V 3.3.0 or before releases.