How to create a collection of all non client systems

Here is a query that helps create a collection to list all the non SMS/SCCM clients.


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.Client is null OR SMS_R_System.Client = 0

0 comments:

Post a Comment