List of PCs with Project, Visio or Visual

For full details, please see this forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/50b2b524-3c11-41c5-a2d5-b8ae979ee3c2/

Select 
	sys.Netbios_Name0, 
	sys.User_Domain0, 
	sys.User_Name0, 
	sys.Operating_System_Name_and0, 
	arp.DisplayName0,
	ARP.Version0
FROM 
	v_R_System sys
	JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID 
WHERE 
	Displayname0 like '%visio%'
	or displayname0 like '%project%'
	or displayname0 like '%visual%'

Leave a Reply

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