Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 09, 2021 09:46 PM
SELECT O.ID, O.FOREGROUND, O.BACKGROUND, O.BLINK, A.SEVERITYDESC, CONDNAME, SUBCONDITIONACTIVETIME AS "Alarm Active Time", O."FullName", MESSAGE, DISABLETIME, DISABLEDENDTIME, DISABLEDBYFROM CALARMOBJECT AS O JOIN CALARM AS A USING ( ID )WHERE STATE = 1 ORDER BY "FullName" ASC
SELECT O.ID, O.FOREGROUND, O.BACKGROUND, O.BLINK, A.SEVERITYDESC, CONDNAME, SUBCONDITIONACTIVETIME AS "Alarm Active Time", O."FullName", MESSAGE, DISABLETIME, DISABLEDENDTIME, DISABLEDBYFROM CALARMOBJECT AS O JOIN CALARM AS A USING ( ID )WHERE STATE = 1 and ("FullName" like '$FullName$.%' or '$FullName$' = '$Root' )ORDER BY "FullName" ASC
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.