Friday, October 1, 2010

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'

1 Comments:

Blogger Mayur Sharma said...

Simply amazing... :)

January 11, 2013 at 12:59 AM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home