Collection Query for clients without SCCM Agent Installed

just build an empty sccm collection with ” Query Rule ” when select the “Membership Rules” if you want to query with non sccm agent machines.

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

Leave a Comment