This SQL query much like its counterpart in the SMS console will provide you with the component status for you site.
SQL Query:
Select
Summarizer_Components.SiteCode Site,
Summarizer_Components.MachineName 'Server Name',
Summarizer_Components.ComponentName Component,
Case Summarizer_Components.Status
When 0 Then 'OK'
When 1 Then 'Stopped'
When 2 Then 'Critical'
When 3 Then 'Unknown'
Else 'Unknown'
End As 'Current Status',
Case Summarizer_Components.State
When 0 Then 'Stopped'
When 1 Then 'Started'
When 2 Then 'Paused'
When 3 Then 'Installing'
When 4 Then 'Re-Installing'
When 5 Then 'De-Installing'
End As 'Current State',
Case Summarizer_Components.Type
When 0 Then 'AutoStarting'
When 1 Then 'Scheduled'
When 2 Then 'Manual'
End As 'StartUp Type'
From summarizer_components
-- Change xxx to the Three letter site code you wish to query.
Where Summarizer_Components.SiteCode = 'XXX'
No Comments