Add acknowledge time and clear time to alarm_events SQL

[Andres_Cortes_Vargas]

I'm trying to pull out the acktime and cleartime from the alarm status table, because the customer wants to have this information in an excel sheet from time to time to determine where an alarm was triggered, when was acknowledge and when it was cleared.

but I don't see that information in the journal database (alarm_event)

Is there a way to get this information?

[PGriffith]

You already have that information.
https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-TableDefinitions

A row with an eventtype of 1 indicates that at that eventtime, the alarm with the id eventid was cleared.
Similarly, eventtype 2 means acknowledged.