This is a “dashboard” report that shows the current SMS site status.

SELECT TOP (100) PERCENT SiteCode, CASE Status WHEN 0 THEN 'OK' WHEN 1 THEN 'Warning' WHEN 2 THEN 'Critical' ELSE 'False' END AS [Level], Updated
FROM dbo.v_SummarizerSiteStatus
ORDER BY Status DESC, SiteCode

SMS Status Example