Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Displaying a List of Disabled Alarms
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we?ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
📖 Home Back
It is possible to create a list which provides a summary of all disabled alarms in a system. This is a common requirement and is simple to configure using the in built Queries.
To configure a disabled alarms list for points:
The list displayed now shows a list of all disabled alarms in the system. You can re-enable the alarms by clicking on the point, and selecting Enable Alarms from the displayed object menu.
Once you have created this list, you can then link to it from any mimic in your system using the Copy Shortcut option from the ViewX Edit menu and then selecting paste on your mimic. You could also add it to your personal favourites list.
To configure a disabled alarms list for all objects, you can edit the SQL and use a query such as the following:
A useful way to use this is to add a Table Query to the Group object so that any user can right-click a group and select an additional menu to show Disabled alarms for that group.
The following image shows how to set this up with the Server Configuration tool:
TableQueryDisable.PNG
The query is:
Go: Home Back
It is possible to create a list which provides a summary of all disabled alarms in a system. This is a common requirement and is simple to configure using the in built Queries.
To configure a disabled alarms list for points:
- Display the Queries Bar by selecting the Queries icon from the Operate toolbar.
- Open the Queries folder from the Queries bar
- Double click on the "Points" list
- From the Filter dialog, click Add...
- From the first drop down, select "Alarm State (AlarmState)"
- In the second drop down, select "Is Equal To"
- In the third drop down, select "Disabled"
- Click OK
- Click OK to display the Disabled Alarms List.
The list displayed now shows a list of all disabled alarms in the system. You can re-enable the alarms by clicking on the point, and selecting Enable Alarms from the displayed object menu.
Once you have created this list, you can then link to it from any mimic in your system using the Copy Shortcut option from the ViewX Edit menu and then selecting paste on your mimic. You could also add it to your personal favourites list.
To configure a disabled alarms list for all objects, you can edit the SQL and use a query such as the following:
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
A useful way to use this is to add a Table Query to the Group object so that any user can right-click a group and select an additional menu to show Disabled alarms for that group.
The following image shows how to set this up with the Server Configuration tool:
TableQueryDisable.PNG
The query is:
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
Go: Home Back
Author
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.