Find programs removed from a PC

This basic query will find all program removed from a PC.

SELECT DISTINCT
 v_HS_ADD_REMOVE_PROGRAMS.Publisher0 AS ‘Publisher’,
 v_HS_ADD_REMOVE_PROGRAMS.ProdID0 AS ‘Product’,
 v_HS_ADD_REMOVE_PROGRAMS.DisplayName0 AS ‘Name’
FROM
 v_GS_ADD_REMOVE_PROGRAMS v_GS_ADD_REMOVE_PROGRAMS,
 v_HS_ADD_REMOVE_PROGRAMS v_HS_ADD_REMOVE_PROGRAMS
WHERE
 v_HS_ADD_REMOVE_PROGRAMS.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID
 AND ((v_GS_ADD_REMOVE_PROGRAMS.DisplayName0<>’v_HS_ADD_REMOVE_PROGRAMS.DisplayName0′)
 AND (v_HS_ADD_REMOVE_PROGRAMS.Publisher0 Is Not Null))

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *