Log in

[Config Mgr] Query to show all clients that do not have a certain package installed

By DimitriC at February 05, 2010 13:49
Filed Under: Configuration Manager, WQL 
   1: select 
   2: SMS_R_SYSTEM.ResourceID,
   3: SMS_R_SYSTEM.ResourceType,
   4: SMS_R_SYSTEM.Name,
   5: SMS_R_SYSTEM.SMSUniqueIdentifier,
   6: SMS_R_SYSTEM.ResourceDomainORWorkgroup,
   7: SMS_R_SYSTEM.Client 
   8: from SMS_R_System 
   9: where SMS_R_System.ResourceId not in 
  10: (select ResourceId 
  11:  from SMS_FullCollectionMembership 
  12:  where CollectionID = "CollectionID"
  13: )

Where “CollectionID” is the ID of the collection created in the previous post.
Tags:
Comments (0) E-mail Kick it! DZone it! del.icio.us Permalink Post RSS
Comments are closed