Collection containing clients with specific software installed but excluding one particular client
Hello everybody I have a collection which contains clients with a specific software installed: 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 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 like "%My Software%" From this collection, I would like to exclude one particular client using it's computer name. Here some SQL statements which could be helpful: inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name != "PCNAME-to-Exclude" I tried it with an AND statement at the end, with brackets or by including another inner join, but with no success (I do not know SQL very well). It would be nice if I can accomplish that goal without creating an extra exclusion-collection to exclude the client, many people were asking about that as I have seen after researching the web for a solution. Thank you for your support.
October 8th, 2010 12:52pm

try this. http://smsug.ca/blogs/garth_jones/archive/2010/10/08/pc-with-app-x-but-exclude-pc-y.aspxhttp://www.enhansoft.com/
Free Windows Admin Tool Kit Click here and download it now
October 8th, 2010 1:27pm

this works, thank you!
October 8th, 2010 2:07pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics