[Alarm Summary] How long can save alarms ?

From the time I started work with Citect in 2010 I remember in Wizard was a parameter "Summary length" in rows (how much alarm can be in Summary? for example we set 10 000, 10 001 alarm will replace the oldest) but in production we want to save alarms in time period ( 3 months or 2 years).

By the reason we didn't use Summary

We used (and using right now) alarm log on web technology: apache + php + SQLite (via ODBC)/ We call it ALARM LOG. At the alarm log page we use an ActiveX element Microsoft Web Browser to display alarms fron our archive/log.

QUESTION: Does Citect in 2019 have any build-in instrument to log/archive alarms for configured period (for example 3 months or 2 years)?

In Citect 2015 help I don't see any descriptions about alarm summary ...... but in Citect 7.1 I remember it was .....

  • Hi Anton,
    With the change in alarm architecture in V7.30, there have been some subtle changes. It is correct that alarm summary length is no longer available. You can only configure the period after which the alarm history is archived or remains in memory.
    You are also correct that if an alarm has been acknowledged and transitions to off state, it will be removed from the active alarm list. You can still access the alarm history by visiting the Alarm Summary or Alarm SOE page. I'd recommend disabling the alarm summary and just using the SOE page, unless you have specific requirements that only the Alarm Summary can deliver.
    There are a number of ways to log alarm history to another database or archive. A Historian is indeed one solution. Another is custom code to read alarms form the alarm event queue and insert into SQL database. You can also just use Alarm Log device, like you mentioned, which points directly to SQL DB.
  • Hi Anton,

    For most customers I use one of the solutions mentions: MS SQL database with custom cicode to read the alarm event queue.
  • --- You can also just use Alarm Log device, like you mentioned, which points directly to SQL DB. ---

    As i wrote above We used (and using right now) alarm log on web technology: Apache + php + SQLite (via ODBC)/ We call it ALARM LOG. At the alarm log page we use an ActiveX element Microsoft Web Browser to display alarms from our archive/log

    A question to you as a man from Citect developers: does Citect have plans to make an alarm archive mechanism like trends (tag, format, period, graphic element to view)?

    Why Desigo Insight or ClearSCADA have an alarm archiving mechanism but Citect in 2019 has only new greyscale template (I am about Situational Awareness Library) ?

    Today's situation with archiving alarms is like graphic element Trend and ProcessAnalyst .....

  • Hi Anton,
    I'm not sure I understand your question. Can you please clearly state what feature and functionality you require for alarm archive?
    Within the product, there is native alarm archiving within the alarm database (actually the ClearSCADA database). The time the alarm archive remains is controlled via citect.ini parameters as mentioned previously. The alarm history is accessible via standard alarm pages (like SOE or Alarm Summary page) and you can also query the alarm database via SQL type query (see the Example project "Database Access" which demonstrates this capability). There is also the ability to hook directly into the alarm event queue and do anything you want with the information (forward to another database). You mention Process Analyst, it is also capable of displaying the alarm history. So there are lots of options and flexibility in the product. It isn't clear what is missing from your description.
  • Hi Anton,

    Are you perhaps looking for an ActiveX object to display your historical alarms from SQLite in a grid-form (rows and columns)?
    If so, please take a look at Citect's DatabaseExchange ActiveX Control. It is already included with the product. The Example project uses it somewhere if I recall it correctly.
  • Yes, I know about DatabaseExchange but it has poor interface than html+css:

     - DatabaseExchange hasn't methods to color each row (we use color row to show alarm category)

    - DatabaseExchange hasn't mathods to make captions for each columns

    - DatabaseExchange has more poor printing interface than MS Web browser ActiveX

  • I totally agree, especially the printing interface. Only way to change portrait/landscape orientation is through the menu bar wchich looks like it was made for Windows 3.11
  • My alarm log in ActiveX MS web browser (php+html+css):

    Print preview of the alarm log (red square is print preview menu):