Find all non-client PCs

 

🙂 at the suggestion of a friend here is a query to find all non-client PCs.

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_R_SYSTEM.ResourceID from SMS_R_System where SMS_R_System.Client = 1)