Create SCCM Collection of SCCM Servers

Query is: 

Select * from  SMS_R_System where SMS_R_System.Name in (select distinct ServerName from SMS_SystemResourceList)

If you find this article useful please leave me a comment or click on an ad to show your support.