Web Report - SMS Site server Component StateTracker

SELECT a.SiteCode,a.Status, CASE a.Status
when 0 then 'OK'
when 1 then 'Warning'
When 2 then 'Critical'
Else 'Unknown'
end as 'Component Health',
a.ComponentName, a.Errors,
a.Warnings,a.State, CASE a.State
when 1 then 'Started'
when 0 then 'Stopped'
Else 'UNKNOWN'
end as 'Component State',
a.LastStarted, a.LastContacted
FROM v_ComponentSummarizer a WHERE a.TallyInterval='0001128000080008'