Want to implement Oracle (RDB) query with live alarms

[fmulder]

We want to develop a ‘Dashboard’ that takes data from Oracle to show the amount of live alarms per station. Can anyone tell me : when is an alarm actually being stored in Oracle. Right away or when the alarm is closed ?

Could you explain : how many records are being stored for an alarm. We believe that it is : CAME, WENT and ACK. Is this correct ? are there 3 records per alarm or more

Does anyone have a query that gives us a list with live alarms ( all CAME’s and the unack’s )

Thanks

Frenk Mulder
Share the fun

[Gertjan van Schijndel]

I got the following answers from the developer:
The alarms are stored at least every 3 three seconds (per default, or setting the flushInterval in the RDBParameterization panel) the records are stored to Oracle.

There are records stored per alarm (1 CAME, 1 WENT, the acknowledge updates the existing record).

If you do a dpQuery-Call in a Ctrl-Script (RDB-Project) and enable -dbg 2 for the UI you will find the correct SQL-Stmt for Oracle.
To be honest I do not exactly know which alarms are shown in the Alert-Screen.

[agruber]

Maybe there is a good reason for you to go with a direct Oracle connection, but why don't you go directly to WinCC OA. I can imagine, you run such a dashboard in a Web environment (a browser), in that case, you could use our webserver. You can even use spontaneous data with websockets if your client supports that (current browsers do), example here:
Integrate values from WinCC OA to any w ... Websockets

BR,
Andreas