Find Programs Removed from a PC (updated)

For full details see:

https://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/db96da44-a9e0-4996-bca2-286b6e2c473a

SELECT DISTINCT 

	CS.Name0,

	HARP.Publisher0 AS 'Publisher', 

	HARP.ProdID0 AS 'Product', 

	HARP.DisplayName0 AS 'Name'

FROM 

	dbo.v_GS_COMPUTER_SYSTEM CS

	join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = CS.ResourceID 

	join dbo.v_HS_ADD_REMOVE_PROGRAMS HARP on HARP.ResourceID = ARP.ResourceID 

WHERE 

	ARP.DisplayName0<>HARP.DisplayName0 

	AND HARP.Publisher0 Is Not Null

union

SELECT DISTINCT 

	CS.Name0,

	HARP.Publisher0 AS 'Publisher', 

	HARP.ProdID0 AS 'Product', 

	HARP.DisplayName0 AS 'Name'

FROM 

	dbo.v_GS_COMPUTER_SYSTEM CS

	join dbo.v_GS_ADD_REMOVE_PROGRAMS_64 ARP on ARP.ResourceID = CS.ResourceID 

	join dbo.v_HS_ADD_REMOVE_PROGRAMS_64 HARP on HARP.ResourceID = ARP.ResourceID 

WHERE 

	ARP.DisplayName0<>HARP.DisplayName0 

	AND HARP.Publisher0 Is Not Null