Tuesday, August 21, 2018

SCCM Collection Role name


I find a different manner to create a dynamic collection for Site role name as usual

In WQL (in a collection)
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.ResourceNames in (Select ServerName FROM SMS_SCI_SysResUse WHERE RoleName='SMS Software Update Point')


change 'SMS Software Update Point' by 1 of below Role


In SQL
SELECT Distinct([RoleName])
  FROM vSMS_SC_SysResUse

RoleName
AI Update Service Point
SMS Application Web Service
SMS Component Server
SMS Distribution Point
SMS Dmp Connector
SMS Management Point
SMS Notification Server
SMS Portal Web Site
SMS Provider
SMS Site Server
SMS Site System
SMS Software Update Point
SMS SQL Server
SMS SRS Reporting Point