Query working but not as subquery?

Question

Hello,

I am trying to use the blogs from Kent: https://blog.ctglobalservices.com/configuration-manager-sccm/kea/query-to-find-computers-without-net-framework-35-sp1-installed/

with a query:

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 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_64.DisplayName like "%System Center Endpoint Protection%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Sophos Endpoint Defense%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%System Center Endpoint Protection%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Sophos Endpoint Defense%"
Blockquote

But I am getting an error:

Any idea?
Thanks,
Dom

Answer 1

A subquery can only have one column.
But you query has flaw... You can't have a inner join on arp64. Take a look at https://www.enhansoft.com/subselect-wql-query-to-find-pcs-that-do-not-have-either-x86-or-x64-versions-of-software-installed/