SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Find Programs Removed from a PC (updated)

For full details see:

http://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

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems