# Alarm end time in SQL

**URL:** <https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688>\
**Category:** Ignition\
**Created:** [November 16, 2020, 2:19pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688 "2020-11-16T14:19:18Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [November 16, 2020, 2:19pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688/1 "2020-11-16T14:19:18Z")

</div>

Hello Ignition’s ninjas 🙂

The table “alarm\_event” in the SQL DB contain these columns:

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

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

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [November 16, 2020, 2:44pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688/2 "2020-11-16T14:44:09Z")

</div>

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](https://docs.inductiveautomation.com/display/DOC81/Alarm+Journal#AlarmJournal-JournalProperties)

---

<div class="post-metadata">

**Author:** ![Baris.kose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/baris.kose/32/18991_2.png) [@Baris.kose](https://forum.inductiveautomation.com/u/Baris.kose)\
**Post date:** [February 22, 2022, 2:19pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688/3 "2022-02-22T14:19:40Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Baris.kose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/baris.kose/32/18991_2.png) [@Baris.kose](https://forum.inductiveautomation.com/u/Baris.kose)\
**Post date:** [February 22, 2022, 2:41pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688/4 "2022-02-22T14:41:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 22, 2022, 3:55pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688/5 "2022-02-22T15:55:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Baris.kose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/baris.kose/32/18991_2.png) [@Baris.kose](https://forum.inductiveautomation.com/u/Baris.kose)\
**Post date:** [February 22, 2022, 7:17pm UTC](https://forum.inductiveautomation.com/t/alarm-end-time-in-sql/40688/6 "2022-02-22T19:17:19Z")

</div>

Thanks!