List of Points configured with Alarms

[bridig]

Hi all

New to GeoScada so exploring the interface and configuration.

Question,

How can I get a list of Points configured with alarms?

I have run a few of the system queries but am not seeing the result I am after.

[geoffpatton · Accepted solution]

There is not just one place for alarms being set. There are many states of points and other objects that can be set to alarm.

You can use SQL queries to get the information refer to the schema to see the table and field names.

You can also use the Bulk Edit tool to retrieve the information. You still may need to refer to the schema to understand the fields/values.

You are probably wanting to know the alarms on digital and analog states you'll be looking for the SeverityType of the state you are looking for. It will be a number 0-2. 0 = None, 1 = Event and 2 = Alarm. For example here are a few field names are State0SeverityType, State1SeverityType, OverrangeSeverityType, HighHighSeverityType.

The Bulk Edit, and other tools for that matter, can be downloaded from this page https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Tools-amp-Samples/ba-p/279123 the download link is at the bottom of the page.

[sbeadle · Accepted solution]

Aside: You can use the SeverityCleaner utility (https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Severity-Cleaner-Tool/ba-p/402064) to find all objects matching a specific alarm severity. (You don't have to use the utility in change mode). e.g. command line:

SeverityCleaner.exe -u AdminExample -a mypasswd -f 1000 -t 1000

will list all items with any states and a severity of 1000

I suppose a variant of this tool could list all alarm states of any severity for a given selection of points ...

[mh2 · Accepted solution]

I have been working on a similar question.

I have added a metadata point to the CDBPoint table to indicate if an alarm has been configured for the point (this needs to be done manually). Then included an SQL query for all points with / without this flag set including point ID. This allows me to navigate from the query to see the point configuration.

I have also found there is a flag for AlarmRedirection. If all your points with alarms configured use redirection, you could filter the same table for this flag.