Software Invetory shows uninstalled Software - After upgrading to ITMS old Software Inventory information is not removed if any Software is uninstalled from the clients

Article:TECH195379  |  Created: 2012-08-22  |  Updated: 2012-08-27  |  Article URL http://www.symantec.com/docs/TECH195379
Article Type
Technical Solution


Issue



If we install any software on a client run SW inventory it will be populated to the DB, uninstalling the software removes the entries from the DB as expected. However there are some historical information about SW which will not be removed if uninstalled on the client.


Error



NA


Cause



Historical SW inventory has different assocciations than newly discovered one after upgrading to 7.0 MR4


Solution



Running the below SQL query will wipe out all the SW inventory information for all the computer clients, Then run Software Inventory on all your clients.

-- Begin of SQL query --
Declare @ID int
Declare @Name varchar (max)
Declare @GUID uniqueidentifier
create table #vcomp
(
[id] bigint identity (1,1) not null,
[Name] varchar (max),
[GUID] uniqueidentifier
)
insert into #vcomp (Name, GUID)   (select name, guid from vComputer)
set @ID = '1'
set @GUID = (select GUID from #vcomp where ID = @ID)
while @GUID is not null
begin
set @GUID = (select GUID from #vcomp where ID = @ID)
set @Name = (select Name from #vcomp where ID = @ID)
exec dbo.[sp_Inv_Installed_File_Details_resource_delete] @GUID
exec dbo.[sp_Inv_InstalledSoftware_resource_delete] @GUID
exec dbo.[sp_Inv_AddRemoveProgram_resource_delete] @GUID
print @Name
Print  @guid
set @ID = @ID + 1
end
drop table #vcomp
-- End of SQL query --

NB. It's highly recommended to take a full database back before applying the above workaround




Article URL http://www.symantec.com/docs/TECH195379


Terms of use for this information are found in Legal Notices