Hello Ignition’s community 
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?
Thanks.
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.
2 Likes
True.
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.
1 Like