Alarm count Monthly Report using Alarm Journal Query

Ignition
,
1

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!

2

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.

3

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

4

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.