Example: pinpointing where alarms occur

This query reports the number of alarms raised from each source by area and by object.

DECLARE @StartTime as varchar(60)

DECLARE @EndTime as varchar(60)

SET @StartTime = '2015-10-25 12:00:00'

SET @EndTime = '2015-10-26 12:00:00'

DECLARE @AlarmRaise table

(

EventTime nvarchar(60),

ID nvarchar(50),

AlarmState nvarchar(20),

SourceArea nvarchar(20),

SourceObject nvarchar(20)

)

INSERT @AlarmRaise select EventTime,Alarm_ID,Alarm_State,Source_Area,Source_Object from Events where EventTime > @StartTime and EventTime < @EndTime and Alarm_State='UNACK_ALM'

--======================--

SELECT SourceArea AS "Source Area/Object" , count(*) AS "Total Number of Alarms" from @AlarmRaise GROUP BY SourceArea UNION

SELECT SourceObject AS "Source Area/Object" , count(*) AS "Total Number of Alarms" from @AlarmRaise GROUP BY SourceObject;

The results look like this: