I have different versions of JRE installed on the network, specifically JRE 1.6 update 16 and JRE 1.5 update 18. Some computers have only have 1.6 update 16 while while others have both. I want to create a collection that contains only computers with JRE 1.6 update 16 and below (below meaning within 1.6.x). This collection will not contain computers that have both JRE versions. I'm having a tough time figuring out how to create this collection. I tried using file versions and also add/remove programs values, but they both pull in computers with both versions. Any ideas would be appreciated. -JD

You can achieve this by creating a subselect query; first you set up a collection (let's call this A) containing all computers with only version 1.6 then set up a global collection containing all other versions, except 1.6 (call this B) Then you set the collection properties as follows: All computers in A, not in B More info about subselect queries: http://verbalprocessor.com/2008/02/26/subselect-query-in-sccm/ good luck!

Create a test collection and use this query and see if it works for what you wantComptuers with Java 1.6 but not 1.5---------------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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java(TM) 6%" and SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java(TM) 5%")---------------------------------------http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com