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%")

Leave a Reply

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