locked
Exclude Clients from a collection based on installed application. RRS feed

  • Question

  •  

    I need to create a clooction for the purpose of distributing an application. The collection needs to include all machines in the office EXCEPT for the machines that have a given application installed. Is there a way to create a query based collection that will satisfy this purpose?
    Monday, July 21, 2008 7:47 PM

Answers

  • Here's one you can C&P:

    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 SMS_R_System.ResourceId from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "<Software Title>") and SMS_R_System.Client = 1

    NOTE: I made this a generic query so you’ll need to change the <Software Title> text between the quotation marks to the display name for the software title you’re after and get rid of the <>’s.

    http://myitforum.com/cs2/blogs/jgilbert/archive/2008/07/22/subselect-queries-the-easy-way.aspx
     

     

    Tuesday, July 22, 2008 5:00 AM

All replies