Finding Adobe X for both x68 and x64

For full details see

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

https://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%")