# Active alarms report

**URL:** <https://forum.inductiveautomation.com/t/active-alarms-report/11286>\
**Category:** Ignition\
**Created:** [February 29, 2016, 4:46pm UTC](https://forum.inductiveautomation.com/t/active-alarms-report/11286 "2016-02-29T16:46:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jado58](https://avatars.discourse-cdn.com/v4/letter/j/cdc98d/32.png) [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\
**Post date:** [February 29, 2016, 4:46pm UTC](https://forum.inductiveautomation.com/t/active-alarms-report/11286/1 "2016-02-29T16:46:30Z")

</div>

Hi,  
I’d like to generate a report for the active alarms to be emailed at the end of the day, what would be a good way to approach this task?

Thanks

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [February 29, 2016, 5:39pm UTC](https://forum.inductiveautomation.com/t/active-alarms-report/11286/2 "2016-02-29T17:39:14Z")

</div>

In 7.8 you can query the Alarm Journal for your data source. Have you tried that?

---

<div class="post-metadata">

**Author:** ![Jado58](https://avatars.discourse-cdn.com/v4/letter/j/cdc98d/32.png) [@Jado58](https://forum.inductiveautomation.com/u/Jado58)\
**Post date:** [March 2, 2016, 7:46pm UTC](https://forum.inductiveautomation.com/t/active-alarms-report/11286/3 "2016-03-02T19:46:37Z")

</div>

I query alarm\_event \_data and , but I’m unable to order by status and priority similar to the way alarms are displayed in the alarm status table, I need this in the form of a report to email out automatically. below is a screen of the tables from SQL [attachment=0]Untitled.png[/attachment]