# Add acknowledge time and clear time to alarm\_events SQL

**URL:** <https://forum.inductiveautomation.com/t/add-acknowledge-time-and-clear-time-to-alarm-events-sql/70538>\
**Category:** Ignition\
**Tags:** vision, scripting, database\
**Created:** [March 2, 2023, 4:05pm UTC](https://forum.inductiveautomation.com/t/add-acknowledge-time-and-clear-time-to-alarm-events-sql/70538 "2023-03-02T16:05:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andres\_Cortes\_Vargas](https://avatars.discourse-cdn.com/v4/letter/a/7ab992/32.png) [@Andres\_Cortes\_Vargas](https://forum.inductiveautomation.com/u/Andres_Cortes_Vargas)\
**Post date:** [March 2, 2023, 4:05pm UTC](https://forum.inductiveautomation.com/t/add-acknowledge-time-and-clear-time-to-alarm-events-sql/70538/1 "2023-03-02T16:05:14Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/1/6131242b80f98cf36248eb79948c0b63bcccc918.png)

but I don't see that information in the journal database (alarm\_event)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/e/ae5cf2517c31de67355b3af44b4cb49f45e83695.png)

Is there a way to get this information?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 2, 2023, 5:12pm UTC](https://forum.inductiveautomation.com/t/add-acknowledge-time-and-clear-time-to-alarm-events-sql/70538/2 "2023-03-02T17:12:39Z")

</div>

You already have that information.  
[https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-TableDefinitions](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.