Is there official support for storing alarms and events in a database such as MS SQL or SQLite?

Hi Rohan Patel ,

I've seen many customers implement their own Alarm storage solutions (in addition to the built-in Alarm storage).

Some examples:

1. AVEVA Historian + AVEVA Plant SCADA Historian Connector to store alarm history. This alarm history can then be quiried via sql commands or oData interface.

2. Setup directly within Plant SCADA, an Alarm device that outputs to a SQL database. See the help topic "Configure SQL Device" and "Add an alarm category" for more information on how to do this.

3. Custom Cicode which opens the alarm event queue and stores each event in a SQL database using the SQL Cicode functions. This is more advanced and requires some engineering to implement.

Hope this information helps.

There might also be examples on the Knowledge Base of the above or Toolbox (https://softwareforums.aveva.com/citect_community/f/toolbox).

Kind regards

Olivier

Hi, 

It is also possible to make sql queries to citect alarm database via the ODBC Citect Alarm Driver. There is a table for realtime alarm values and another for historical alarms and events.

Hi, 

It is also possible to make sql queries to citect alarm database via the ODBC Citect Alarm Driver. There is a table for realtime alarm values and another for historical alarms and events.