Alarm Server Database Specification

List of available Alarm Server Database tables.

Sample SQL Query:

SELECT CIAlarmObject.AlarmSource, COUNT (CDBEventJournal.Id) as "Number of

Alarms"

FROM (((CDBEventJournal LEFT OUTER JOIN CIAlarmObject ON

CDBEventJournal.Id=CIAlarmObject.Id) LEFT OUTER JOIN CIAnalogAlarm ON

CDBEventJournal.Id=CIAnalogAlarm.Id) LEFT OUTER JOIN CIMultiStateDigAlarm ON

CDBEventJournal.Id=CIMultiStateDigAlarm.Id)

GROUP BY CIAlarmObject.AlarmSource, CDBEventJournal.Id

ORDER BY 2 DESC

See Also

Published June 2018