ConfigMgr 2012 Query for All Site Systems

less than 1 minute read

Did you ever want to create a collection with all ConfigMgr site servers? I like to create one for Endpoint Protection exceptions, but I want to to be a query so servers are automatically added. Here is the query I use:

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 ResourceNames[0] IN (Select Distinct ServerName FROM SMS_SystemResourceList)

Leave a Comment