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%'