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.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Try This

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 in (Select ResourceID From SMS_G_System_ADD_REMOVE_PROGRAMS where DisplayName = 'Adobe Reader 9.3.1 ')
Answered 04/16/2010 by: langa100
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity