KNOWN ISSUE: The Server Inventory Clean Up Old Inventory process does not remove associated rows from the ResourceUpdateSummary, causing database integrity issues with Inventory
Last Updated March 08, 2016
The Server Inventory Clean Up Old Inventory process does not remove associated rows from the ResourceUpdateSummary, causing database integrity issues with Inventory.
Symptoms include if Server Inventory is recaptured from that system, it will not be processed into the database due to the check against the ResourceUpdateSummary table to see if the data already exists in the database. It will not verify if the data is really there or not as this table should only be updated if data is inserted into the associated data classes.
The stored procedure, when deleting data from Server Inventory tables, should clear out the associated rows in ResourceUpdateSummary. By not doing this, any future inventory sent may not be inserted back into the database for that resource as it thinks it still has the data based off of the RUS table.
Attached to this article is a modified version of the stored procedure that cleans a specified computer out of Inv_AeX_AC_Client_Agent. The modified version removes the GUID of the specified computer from ResourceUpdateSummary for all basic inventory data classes.