[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 436
  • Last Modified:

How can I exclude a collection of machines from an SMS deployment targeted to "All Systems"?

I need to deploy an application to all of our systems - except a small group of computers.  This exception group will change in the future.  I would like to find out if there is any way to apply this add to the "All Systems" collection - while exluding the "Excusion Systems" collection.
0
tneubauertocg
Asked:
tneubauertocg
1 Solution
 
JonLambertCommented:
You can do this by creating a new collection that has a query that includes all systems excep those in the 'exception'' collection, e.g.

SELECT DISTINCT
  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_FullCollectionMembership
                                          WHERE  collectionid IN ('0010001A'))
0
 
tneubauertocgAuthor Commented:
This is the PERFECT solution that I know will be used over and over.  Thank you very much!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now