*** updated to use spaces instead of tabs ***
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_G_System_ADD_REMOVE_PROGRAMS.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS
where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%Symantec Endpoint Protection%”)
and SMS_R_System.ResourceId not in (select SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID
from
SMS_G_System_ADD_REMOVE_PROGRAMS_64
where
SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like “%Symantec Endpoint Protection%”)