SOLVED Trying to create collection for machines without certain progrm

[jrt]

Hi all, I spent agents on google and other forums, still can't get this to work.

The software is called Smoothwall Safeguarding Client, this is how it appears in control panel.


The script in SCCM is:
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_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName != "Smoothwall Safeguarding Client"

I have tried with and without the % in the name of the app. The collection seems to bring up all my machines whether its Like or Not Like.

Any ideas?!

What I am trying to achieve is the ability to work out which machines don't have the software so we can troubleshoot them. Thanks!

 

[Garth]

You need to use a subselect query. These blogs will get you going.

The Subselect Query

in this article, I will show you how a subselect query works and why your woudl want to use one within either collection or report.

askgarth.com

How a Not Equal To Query is Processed

When a query is run, it processes each row within a view or a table. This post examines how the Not Equal To operator is processed.

askgarth.com

 

[Garth]

and these ones.

Creating a Subselect Query for WQL - Recast

Today’s blog post will show you how to create a subselect query for WQL, and we will find which PCs do not have Microsoft Project 2010 installed. For more information about how queries are processed, please start from the first blog post in this series. Here are some subselect query writing tips...

www.recastsoftware.com

Subselect WQL to Find PCs That Don't Have x86 or x64 Versions of Software

In my blog post series about how queries are processed, I showed you yesterday how to create a subselect WQL query to find all PCs without Microsoft

www.recastsoftware.com

 

[jrt]

Thanks will try those.