Reading Alarm and Value Archives without WinCC OA

[yavaskoray]

Hello Gents,

I would like to know if it is possible to read the Alarm and Value Archives with an external software?

or is it possible to save or convert the Alarm and Value archives in .csv format or in another format? We would like to read these archives without WinCC OA.

Regards,

Koray

[amichon]

Two solutions : make a query adapter through a XML-RPC script controller allowing an external software to query WinCC OA, or make a script exporting alarms periodically in CSV format. In these two cases, please read the help, see dpQuery. The query should be like that "SELECT ALERT ... TIMERANGE ..."
You can experiment with SQL Query in Report Tools.

[yavaskoray]

Thanks for the advice!

So, it sounds it is not possible to open/read the backuped archives without WinCC OA? :unsure:

[leoknipp]

If data is saved in the WinCC OA internal database (RAIMA for alerts, value archives for events) it is not possible to read data without WinCC OA.
When using Oracle archiving (RDB manager) you can read data directly from the Oracle database.

If you want to save data in a different format please keep in mind that it might be a lot of data if every historical information for all dp elements shall be saved.
Also it needs to be taken into account that correction values can be written in WinCC OA. If data is already exported and modified afterwards there is a difference between exported data and data saved in WinCC OA.
For alerts you have to keep in mind that the information for an alert can also be modified, e.g. when an alert is gone the came alert is also updated with new information. It is the same when an alert will be acknowledged.
If this data was already exported before the alert information was changed, also data will be different.

Best Regards
Leopold Knipp
Senior Support Specialist