SMS报表：查询当前站点状态

名称: 当前站点状态

类别: SMS Site – 概要

描述: 现实当前SMS站点状态.

SQL 查询语句：

Select

SiteCode Site,

'Status' = Case

When Status = 0 Then 'OK'

When Status = 1 Then 'Warning'

When Status = 2 Then 'Critical'

Else ' '

End,

Updated 'Time Stamp'

From V_SummarizerSiteStatus

Order by SiteCode