Hello, I tried solving this thing with a different approach than you’ve suggested. I used a power table and applied a SQL Query:
SELECT TOP 10 * FROM (SELECT ROW_NUMBER() OVER (PARTITION BY eventid ORDER BY eventtime DESC) AS RN, * FROM alarm_events WHERE displaypath LIKE ('Station' +(CAST 1 AS VARCHAR(10)) + ' %')) alarms WHERE RN = 1 AND eventtype = 0 ORDER BY eventtime DESC
I want to know one thing though regarding the alarm status table. When I see the data in the power table I can see some items on retracing back in the main alarm status table which shows all the alarms are nowhere to be found.
So my question is that why I can’t see an alarm that would have cleared after been active from the alarm status table and still visible in the database table of alarm events.
The second question is a silly one, just like we can access the data from the database table, how we can access the data coming in the pre-build component of the alarm status table.