~/2007/08/01/sms-site-status.md

SMS Site Status

---
author: Tom Lasswell
date: 2007-08-01
updated: 2024-02-12
read: 1 min
in:   [engineering]
tags: [reporting, sms2003]
---

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