I've figured out how to create queries/collections based on if it has specific software versions installed but I can't figure out how to do it the other way. I have a large number of computers that have several versions of Java Runtime Edition installed and my goal is to only have the latest version installed. This is an attempt to rid ourselves of all vulnerable versions of JRE below JRE6U20. All my install/uninstall packages work correctly when advertised. I want to create a query that returns all systems that don't have JRE6U20 installed. I will then advertise JRE6U20 to it and wait for it to install. Then I will advertise the uninstall packages to systems after JR6U20 has been installed on all systems. I've tried many things but I'm at a loss. The product code for JRE6U20 is {26a24ae4-039d-4ca4-87b4-2f83216020ff}. What would be the best way to approach this?

Here is a collection query that should work for you, just change it to the application name as it appears in Add/Remove Programs. 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 where SMS_R_SYSTEM.ResourceID NOT IN (Select ResourceID from SMS_R_System 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 = "Microsoft Office 2007 Professional Plus")Scott Gill SCCM Consultant