Application was uninstalled but still shows in Inv_AddRemoveProgram Table

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

You have uninstalled an application and verified it is not showing in Add/Remove programs, but you still see the application listed for the computer in the Inv_AddRemoveProgram table. You have a custom report or are exporting the data to another data system. 

Environment

ITMS 8.x

Cause

When an installed application that was previously inventoried is uninstalled, the next time the Delta software inventory runs, it will update the Inv_AddRemoveProgram table by setting the InstallFlag field to 0. The next time a Full software inventory runs, the system will delete the entry for that application from the table. Any custom reports that do not account for the InstallFlag value will show the application as installed until the Full inventory runs. 

Resolution

For custom reports, include the following in your where clause as an element accounting for the InstallFlag field - for example:

where InstallFlag = 1 

If exporting data from the Inv_AddRemoveProgram, include a filter for the InstallFlag.