I am preparing a report of alarms that had a duration exceeding a certain value. My first thought was to create a stored procedure that extracts all values (for a limited time-range of course) from the RDB for the DPE's that I am interested in and then attempts to analyse which ones have crossed a fixed threshold and for how long.
But... part-way through this assignment I realised that there must be an easier way of doing this by looking at how long a DPE has spent in alarm. Is this information available somewhere? is there perhaps a column in ALERTHISTORY or ALERTHISTORYVALUES in the RDB?