# Active alarms from journal tables

**URL:** <https://forum.inductiveautomation.com/t/active-alarms-from-journal-tables/25232>\
**Category:** Ignition\
**Created:** [May 22, 2019, 3:17pm UTC](https://forum.inductiveautomation.com/t/active-alarms-from-journal-tables/25232 "2019-05-22T15:17:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![f.pinciaroli](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/f.pinciaroli/32/6101_2.png) [@f.pinciaroli](https://forum.inductiveautomation.com/u/f.pinciaroli)\
**Post date:** [May 22, 2019, 3:17pm UTC](https://forum.inductiveautomation.com/t/active-alarms-from-journal-tables/25232/1 "2019-05-22T15:17:51Z")

</div>

Hello,

Is there a way to select active alarms from journal tables (alarm\_event\_data & alarm\_events) in DB?

I would like to get the same data returned by system.alarm.getStatus().

Thanks,  
Federico.

---

<div class="post-metadata">

**Author:** ![louagejasper](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/louagejasper/32/86311_2.png) [@louagejasper](https://forum.inductiveautomation.com/u/louagejasper)\
**Post date:** [October 25, 2021, 9:59am UTC](https://forum.inductiveautomation.com/t/active-alarms-from-journal-tables/25232/2 "2021-10-25T09:59:45Z")

</div>

Is there any functionality like this? I would like to see something like this to.

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [October 25, 2021, 4:49pm UTC](https://forum.inductiveautomation.com/t/active-alarms-from-journal-tables/25232/3 "2021-10-25T16:49:36Z")

</div>

You can query the alarm\_events table, though you will need to decipher the meanings of the eventtype and eventflags fields. From some brief testing i believe an eventtype of 2 and a eventflags of 0 is a cleared and acknowledged alarm. Maybe someone will chime in with more info.
