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
Advertisements
Tagged with: , , ,
Posted in Configuration Manager 2012 R2, SCCM 2012 R2, System Center 2012 R2

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Follow Kristopher Jon Turner on WordPress.com
Archives
%d bloggers like this: