Hello Ignition’s ninjas 
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:
https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-JournalProperties
Hello!
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.
Thanks!