/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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