Opened the Console > Reports > All Reports > Software > Patch Magagement > Diagnostics > Windows System Assessment Scan Summary:
Confirmed Clients were not being purged from the database as they were decommissioned in the environment.
This was causing stale Scan data in reporting and low Compliance counts as the old Client’s IP’s was recycled, the new Client continued to utilize that IP with returning updated inventories in conjunction to the old computer record, and this made it appear as if the old computer was still active.
Review the following options:
The attached SQL provides a report that will allow you to view the inventory for the current computers. You can execute it manually using SQL Server Management Studio, or follow these steps to create a report: