Get all pending alarms

[aleksandar.postolov]

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

[leoknipp]

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

[aleksandar.postolov]

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

[aleksandar.postolov]

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

[leoknipp]

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

[YedilethContreras]

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

[leoknipp]

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