SCCM Report to get All Site Server & System with there Roles

select distinct sys1.ServerName, sys5.Caption0 as ‘Operating System’, CASE sys4.SystemType0 WHEN ‘x64-based PC’ THEN ‘x64’ WHEN ‘x86-based PC’ THEN ‘x86’ END as ‘Type’, sys2.SiteCode as ‘Site Code’, sys2.SiteName as ‘Site Name’, sys2.ReportingSiteCode as ‘Parent Site Code’, (select CASE sys3.RoleName WHEN ‘SMS Site Server’ THEN NULL WHEN ‘SMS Component Server’ THEN NULL WHEN ‘AI Update Service Point’... Continue Reading →


Create a free website or blog at

Up ↑