First-out alarm pareto

Hello Ignition’s community :slight_smile:

We have a plc that return the first out alarm in a register. This register is an integer relative to the first alarm that cause the stop of the machine.

This integer can be match with a corresponding alarm message (I would see a table 3 columns: Machine, IntegerValue, Message).

My goal is to show a pareto of the Top 10 first-out.

How would you do this?


One way would be to monitor the integer value tag and fire a tag change script that loads a database table each time the value changes.
You could then query that table and sort by the top 10 most frequent alarms over a given period.

1 Like


I was wondering that could be done using more standards functions of the historian…

If it’s not possible then yes we will do some specific SQL.