Question

How do I determine the current alarm count (number of configured alarms) in a Geo SCADA Database?

In addition, how do I retrieve a list of all configured alarms?

Answer

Example 1)

The following query will show the total number of configured alarms in the GS database:

SELECT

COUNT(*)

FROM

CALARM

If the above query is entered in a list on a mimic, the result will look similar to the screen shot below:

The number in the list represents the total number of alarms that are configured in the Geo SCADA database (not the current number of active alarms).

Example 2)

The following query will show all configured alarms in the GS database:

SELECT

*

FROM

CALARM

I.E.

The number of rows in the list equals the number of alarm conditions that are configured (I.E. the maximum number of configured alarms in the database – not the number of active alarms).

Example 3

The 2nd query above may be edited to see the Object ID number for each of the alarms as follows:

SELECT

CONDNAME, ID, ID, STATE, STATEDESC

FROM

CALARM

I.E.

The ID field represents the database object.  Configured Alarms showing in the ‘Condition Name’ column, that share the same ID, are all from the same database object.

Example 4)

The third query above may be edited to see only alarms for a specific Object ID number as follows:

SELECT

CONDNAME, ID, ID, STATE, STATEDESC

FROM

CALARM

WHERE

ID = 8184

I.E.

The configured alarms in this list are all from the same database object.  (In this case, the object is a Modbus – Advanced Generic Direct Outstation)

In all of these queries, the alarm conditions shown in the list do not represent active alarms (or objects that are currently in alarm).  They only show items that are configured to go into alarm (should the criteria for entering an alarm state be met).

The Geo SCADA server can display up to 250,000 simultaneous alarms.  The queries above can help to illustrate how many ‘potential’ alarms could be active at a given time (I.E. if all alarms happened to go true at the same time).  This is more of a theoretical number, however, as the likelihood of all alarm conditions being true at the same time is incredibly low.

Released for: Schneider Electric Ireland