Files that have been upgraded or removed still show in Inventory reports

Products

• Inventory Solution

Issue/Introduction

Files that have been deleted or upgraded to newer versions still show as existing when viewing a computer's inventory or running an inventory report.

Cause

When a file is upgraded or deleted, an NSE is sent up at the time Inventory detects the removal/upgrade that removes the row for that computer. If that removal does not occur for whatever reason (NSE is "lost", processing error, etc.) another NSE to remove it is never sent, resulting in the file still showing as present in Inventory.

Resolution

The following process refreshes all file data on all systems. It is crucial to run a Full Inventory on all systems after the process to get all current file data back.

1. Back-up your database as a precaution!
2. Run the following SQL:
           TRUNCATE TABLE Inv_Installed_file_Details
3. Now run this SQL query:
           DELETE FROM ResourceUpdateSummary
           WHERE InventoryClassGuid = 'A3855A05-D687-4969-8356-94717DF261F2'
4. Make sure to run a full Software Inventory (including the file scan data) on all systems.