SOLVED create collection based on query

[dj3094]

Hello all

I am trying to create a collection to get the machine that does not have McAfee, I am using the below query but not able to get the results. Am i missing anything or what wrong am I doing?

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 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.DisplayName not like "%McAfee Endpoint Security Threat Prevention%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName not like "%McAfee Endpoint Security Threat Prevention%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "%McAfee VirusScan Enterprise%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName not like "%McAfee VirusScan Enterprise%"

Thanks

 

[Garth]

This blog will help you. https://www.enhansoft.com/blog/subs...her-x86-or-x64-versions-of-software-installed

 

[dj3094]

Thanks Garath, I tried it but didn't work.
I got the results
here is what I did
Create a collection with all work stations
create a collection with Mcafee virusscan enterprise installed
create a collection with Mcafee Threat prevention enterprise installed

I excluded them from all work stations

 

[Garth]

There is more than one way to do it. If this works for you then, use it.

 

[dj3094]

Thanks Garath