SMSUG.ca

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

Garth Jones

Finding Adobe X for both x68 and x64

For full details see

http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/66c80e66-9760-49b3-b429-08bf2ca8f572

http://social.technet.microsoft.com/Forums/en-US/configmanagerapps/thread/b68ce42c-98f5-4500-bced-0e8e901cb211/

select distinct 
	SMS_R_SYSTEM.ResourceID,
	SMS_R_SYSTEM.ResourceType,
	SMS_R_SYSTEM.Name,
	SMS_R_SYSTEM.SMSUniqueIdentifier,
	SMS_R_SYSTEM.ResourceDomainORWorkgroup,
	SMS_R_SYSTEM.Client 
from 
	SMS_R_System 
where 
	SMS_R_SYSTEM.ResourceID not in 
		(select 				
			SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID
		from 
			SMS_G_System_ADD_REMOVE_PROGRAMS 
		where 
			SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Adobe Reader X%" )
	and
	SMS_R_SYSTEM.ResourceID not in 
		(select 
				SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID
		from 
			
			SMS_G_System_ADD_REMOVE_PROGRAMS_64 
		where 
			SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "Adobe Reader X%")
Published Jul 02 2012, 08:45 AM by Garth
Filed under: , , , , , ,

Comments

No Comments

This Blog

Syndication

News

Training

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