# 7.6 Active Alarms Distributed System

**URL:** <https://forum.inductiveautomation.com/t/7-6-active-alarms-distributed-system/7701>\
**Category:** Ignition\
**Created:** [December 13, 2013, 12:34pm UTC](https://forum.inductiveautomation.com/t/7-6-active-alarms-distributed-system/7701 "2013-12-13T12:34:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gadgetguru69](https://avatars.discourse-cdn.com/v4/letter/g/e274bd/32.png) [@gadgetguru69](https://forum.inductiveautomation.com/u/gadgetguru69)\
**Post date:** [December 13, 2013, 12:34pm UTC](https://forum.inductiveautomation.com/t/7-6-active-alarms-distributed-system/7701/1 "2013-12-13T12:34:25Z")

</div>

We have our system setup where we have several remote machines that all log alarms locally and then also log alarms to the office at the same time. The thing is i need a way to show active alarms at the office also. Since there is no alarming system at the office the normal components and scripts won’t work. It would need to be db driven.

Does anyone have the queries needed to make this work.

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [December 27, 2013, 11:32pm UTC](https://forum.inductiveautomation.com/t/7-6-active-alarms-distributed-system/7701/2 "2013-12-27T23:32:57Z")

</div>

You could start with something like this:`SELECT * FROM alarm_events e LEFT JOIN alarm_event_data d ON e.id = d.id ORDER BY e.eventtime`And then filter out the d.propname values that you don’t want.

---

<div class="post-metadata">

**Author:** ![gadgetguru69](https://avatars.discourse-cdn.com/v4/letter/g/e274bd/32.png) [@gadgetguru69](https://forum.inductiveautomation.com/u/gadgetguru69)\
**Post date:** [April 1, 2014, 10:13pm UTC](https://forum.inductiveautomation.com/t/7-6-active-alarms-distributed-system/7701/3 "2014-04-01T22:13:28Z")

</div>

Robert  
Been off on several other projects and just got back to this. Your query just gets all the alarms in the database that’s not what i need. I need the currently active alarms ie alarms in alarm at the remote location. Just using the alarm table i dont see how this could be done but maybe i am missing something. I would think we would need some way to hook to the remote alarm journal to get this live status info to the remote site.

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [April 18, 2014, 9:32pm UTC](https://forum.inductiveautomation.com/t/7-6-active-alarms-distributed-system/7701/4 "2014-04-18T21:32:39Z")

</div>

Add a where clause containing your condition, something like WHERE …

` eventtype = 0 `for active alarms

`source like '%path/to/folder/or/alarm%'`to filter by path,

or

```auto
displaypath like '%displaypath_if_you_use_it%'
```

You can find a good description of the Alarm Journal schema here: [http://www.inductiveautomation.com/support/usermanuals/ignition/index.html?alert\_storage.htm](http://www.inductiveautomation.com/support/usermanuals/ignition/index.html?alert_storage.htm)