Dynamic collection: How to exclude few Hosts?

[Zubof]

I have few dynamic collections for software installations. Query checks Application from "Add/Remove Programs" and install it, if it's missing. Purpose is to install few applications (for example Adobe Reader X) to all 1000 machines where it doesn't exist yet.

 

Query is this and it works fine.

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 where 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 "%Adobe Reader X%" )

 

Problem is to exclude some machines, where I don't want to install Adobe Reader (for the reason, example there is Acrobat Professional already installed). Does anyone know how this could be done?

[Peter van der Woude]

Just add an exclude to the query. Something like

not in (select ResourceID from SMS_CM_RES_COLL_XXX00000)