Blog Archives

ConfigMgr 2012 R2 Collection Query – Systems by System Roles

Recently I needed to create collections that would contain servers with certain site system roles.  For instance I needed a collection that would list all the Distribution Point.  Here is the query that I used: 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

Tagged with: , , ,
Posted in Configuration Manager 2012 R2, SCCM 2012 R2, System Center 2012 R2
Follow Kristopher Jon Turner on
Follow me on Twitter