Simplest Way To Count Total Times A Tag Alarms

Ignition
1

As the title suggests. What is a way I can count the amount of times a tag alarms

2

Querying the alarm history table will be your best option

3

I tried:

SELECT COUNT(*) AS alarmCount
FROM alarm_events
WHERE source = 'path/to/your/alarm'
AND eventtype = 0 -- 0 = Active

But get 0 returning which is wrong since one of the tags I try with is currently alarmed

4

source is a qualified path like "prov:default:/tag:path/to/your/alarm"

You can either get the exact source which will make the query faster, or you can use LIKE

5

Ah yes that could be why. I will give it a try tomorrow and let you know my findings. Thank you for your insights