Queries involving software

[Kevin79]

I am setting up SCCM 12 and creating groups to install software. I have a collection set up to deploy Adobe Reader. In that collection, I have two queries set up, 1 that checks for 10.0.0 and one that checks for 10.1.0. It seems like they are an "and" collection so all of the clients are showing up because they only have one. How do I create a query (or collection) that will check for the software and be satisfied if it finds one of the two versions? Is there a way to put a minimum value and anything greater than that is considered installed?

 

Attached is a screen shot of what my collection looks like. Below are the two queries.

 

Adobe Reader X 10.0.0 - English

select 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.SystemGroupName = "<group name>" and 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 = "Adobe Reader X") and SMS_R_System.ResourceId in (select ResourceID from SMS_FullCollectionMembership where CollectionID = "HOL0000E")

 

Adobe Reader X 10.1.0 - English

select 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.SystemGroupName = "<group name>" and 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 = "Adobe Reader X (10.1.0)") and SMS_R_System.ResourceId in (select ResourceID from SMS_FullCollectionMembership where CollectionID = "HOL0000E")