SMSUG.ca

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

Garth Jones

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%'
Published Jun 01 2012, 06:53 AM by Garth
Filed under: , , , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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