SIMATIC WinCC Open Architecture Forum

What's the query like, to get all pending alarms? it doesn't matter if they are acknowledged or not.
Or is there a function which can be used?

Best regards
aleks

With the function dpQuery("SELECT ALERT ....); you can get all pending alerts based on the definition of the query string.

Best Regards
Leopold Knipp
Senior Support Specialist

Thank you for you reply!

I already tried with SELECT ALERT. But wich statement should I use?
If I use the following query, I recive more alarms, than there should be.

dpQuery("SELECT ALERT '_alert_hdl.._value FROM *.in.*.value)

best regards
Aleks

I found the solution. I need to add a WHERE to filter alarms and events.
SELECT ALERT '_alert_hdl.._prior' FROM '*.in.*.value' WHERE '_alert_hdl.._prior' > 5 AND _DP NOT LIKE "_rm*"

Thank you for the hint
Aleks

Just for clarification (for other users in the WinCC OA forum) in WinCC OA the name "event" is used for a value change (_original config).
The Event Screen is displaying value changes = events.
The Alert Screen is displaying alarms/alerts.

In this special cases the customer has used the name "event" for an alarm with low priority.

Best Regards
Leopold Knipp
Senior Support Specialist

Hi,

Is it posible to join events (Value changes) and alerts (Alarms/Alerts) in an unique list/table?
I would like to unify the info columns shown and, to join events and alerts in the same list.
Regards,

Yedi

There is no standard solution available to display alerts and events in one table.
You can build a solution on your own. You have to take into account that alerts and events have different attributes and you will have to use 2 query connect functions to get all the data.

Best Regards
Leopold Knipp
Senior Support Specialist