Rui Qiu's Tech Blog
← Back to all posts

June 30, 2015

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