Systems Management

I use SCCM SP2 on server 2008R2

I have tried for several! days to build a query that does this:
Adobe Reader package advertise to a collection.
Collection query:
If program does not exist in add remove programs and if computer are member of this AD Group=install

this my current status:
select SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "adobe reader%" and SMS_R_System.SystemGroupName = "domain\\sccm.AdobeReader") order by SMS_G_System_COMPUTER_SYSTEM.Name

But it just gives me all PC's anyway, and when showing installed programs to on list, gives me alle program exept adobe reader.
What am i missing?


Found this on the internet, but it wont work with the applied MSI package info, so therefore i will try to use display name in Add remove programs instead:
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.ResourceId NOT IN (select ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where ProdID = '{xxxxxx}')

Really hope you can help.