Alarm end time in SQL

Hello Ignition’s ninjas :slight_smile:

The table “alarm_event” in the SQL DB contain these columns:

How do I know the end time of a particular alarm?

I think you’d want to query for a particular event where eventtype is 1 (cleared).

Scroll down to “table definitions” here for eventtype and eventflags meanings:


if eventtype is 1, it means the alarm finished. It is okay, but, i was wondering that what is the its end time? when been has cleared?

Thanks in advance.

one way, when the table is triggered, like eventtype set from 0 to 1, we can get datetime directly from mssql?

Use the eventid to look up more information in the details table.