PCs without SEP

*** 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%”)

Leave a Reply

Your email address will not be published. Required fields are marked *