/build/static/layout/Breadcrumb_cap_w.png

SCCM app deploy query - please help

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

Answers (1)

Posted by: langa100 11 years ago
Senior Yellow Belt
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 ')
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ