Alarm Server Database Specification
- Last UpdatedJul 18, 2023
- 1 minute read
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