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 where SMS_R_System.SystemRoles = “SMS Distribution Point”

The following values are also available.  Just replace “SMS Distribution Point”:

  • All Update Service Point
  • SMS Application Web Service
  • SMS Component Server
  • SMS Management Point
  • SMS Notification Server
  • SMS Portal Website
  • SMS Site Server
  • SMS Site System
  • SMS Software Update Point
  • SMS SQL Server
  • SMS SRS Reporting Point

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s