# Alarm count Monthly Report using Alarm Journal Query

**URL:** <https://forum.inductiveautomation.com/t/alarm-count-monthly-report-using-alarm-journal-query/109167>\
**Category:** Ignition\
**Tags:** ignition81, reporting\
**Created:** [July 30, 2025, 8:04pm UTC](https://forum.inductiveautomation.com/t/alarm-count-monthly-report-using-alarm-journal-query/109167 "2025-07-30T20:04:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![janderson1](https://avatars.discourse-cdn.com/v4/letter/j/439d5e/32.png) [@janderson1](https://forum.inductiveautomation.com/u/janderson1)\
**Post date:** [July 30, 2025, 8:04pm UTC](https://forum.inductiveautomation.com/t/alarm-count-monthly-report-using-alarm-journal-query/109167/1 "2025-07-30T20:04:11Z")

</div>

Hello again!

Hoping this is as simple as I assume it is- but I can't quite get it to work.

I have alarms configured and (seemingly) working, and they are logging to a MySQL database. In my report, I want a monthly count of how many times each alarm was triggered.

For instance, if I had 100 alarms configured, but only 15 of them occurred during the month of July, then it would show the 15 tagnames of the alarms that had occurred in one column, and the count of how many times they had occurred in the next column.

I'm seeing a huge list of options for the alarm\_journal data source that I've created for my report, one of which is "Count", but it only returns N/A. Additionally, I see the itemName option, which seems to correctly identify the tagname. Finally, and this is the least important, once I have a count of how many times each alarm occurred- can I display how many -total- alarms occurred; meaning the sum of all the counts?

Thanks in advance for any help!

---

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [July 31, 2025, 12:27am UTC](https://forum.inductiveautomation.com/t/alarm-count-monthly-report-using-alarm-journal-query/109167/2 "2025-07-31T00:27:19Z")

</div>

There is a project in the exchange that has all the named queries for getting all the alarm statistics over any period of time. I used it recently and modified it a bit to filter by display path, but it worked really well.

> **[Ignition Exchange](https://inductiveautomation.com/exchange/95/overview)**
>
> Discover, share, and download community made Ignition resources in collaboration with your organization or the Ignition community.

---

<div class="post-metadata">

**Author:** ![janderson1](https://avatars.discourse-cdn.com/v4/letter/j/439d5e/32.png) [@janderson1](https://forum.inductiveautomation.com/u/janderson1)\
**Post date:** [July 31, 2025, 2:28am UTC](https://forum.inductiveautomation.com/t/alarm-count-monthly-report-using-alarm-journal-query/109167/3 "2025-07-31T02:28:47Z")

</div>

Sorry, I'm not quite sure what this is- could you explain it to me?

---

<div class="post-metadata">

**Author:** ![robertm](https://avatars.discourse-cdn.com/v4/letter/r/ea5d25/32.png) [@robertm](https://forum.inductiveautomation.com/u/robertm)\
**Post date:** [July 31, 2025, 3:26am UTC](https://forum.inductiveautomation.com/t/alarm-count-monthly-report-using-alarm-journal-query/109167/4 "2025-07-31T03:26:02Z")

</div>

It's a prebuilt project/template that extracts all the statistical data from alarm journal db. You can download it and import it into your gateway as a project and you can learn all the various query means to extract alarm occurences, number of each type (active, unack), alarms that occurred the most, the longest duration, etc. It was helpful to me to learn named queries as an example to follow.