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