SCCM query to check Site System roles

This report will show each SCCM site system role:

SELECT     

ServerName, MAX(CASE rolename WHEN 'SMS Management Point' THEN 'X' END) AS [SMS Management Point],

                      MAX(CASE rolename WHEN 'SMS Site Server' THEN 'X' END) AS [SMS Site Server],

MAX(CASE rolename WHEN 'SMS SQL Server' THEN 'X' END)

                      AS [SMS SQL Server], MAX(CASE rolename WHEN 'SMS Distribution Point' THEN 'X' END) AS [SMS Distribution Point],

                      MAX(CASE rolename WHEN 'SMS Reporting Point' THEN 'X' END) AS [SMS Reporting Point],

                      MAX(CASE rolename WHEN 'SMS Server Locator Point' THEN 'X' END) AS [SMS Server Locator Point],

MAX(CASE rolename WHEN 'SMS Client Access Point' THEN 'X' END) AS [SMS Client Access Point],

MAX(CASE rolename WHEN 'SMS Component Server' THEN 'X' END) AS [SMS Component Server],

MAX(CASE rolename WHEN 'SMS Site System' THEN 'X' END) AS [SMS Site System]

FROM         v_SystemResourceList

GROUP BY ServerName