Page History

Download the Solution Example Here: AlarmHistoryFilter.dbsln

Solution Name: AlarmHistoryFilter

Software Version:  10.0.6Keywords:  Alarm. History Filter Runtime.1

Summary

This sample example shows how to filter Alarm History AlarmHistory data using start and end dates and SQL statements as filters.

The Alarm Viewer object allows to show Online Alarm, Historian Alarms or Audi Trail logs. 

In order to select the historian time-frame, the Alarm Viewer object uses the fields Start and EndDateTIme.

This example shows use calendar or SQL queries to populate the Start and End fields.

Technical Information

The Alarm Viewer object allows to show Online Alarm, Historian Alarms or Audi Trail logs. 

In order to select the historian time-frame, the Alarm Viewer object uses the fields Start and EndDateTIme.

This example shows use calendar or SQL queries to populate the Start and End fields.

Technical Information

By default, AlarmViewers show online Alarms – that is, Alarms that have yet to be acknowledged and normalized. To view previously active Alarms, double-click an AlarmViewer in Draw mode and change the List checkbox to AlarmHistory. By default, this will show all of the alarms in the AlarmHistorian dataset, which you can find on the Datasets → DBs table.

To improve visualization, you can filter the AlarmHistory by dates, or by using SQL queries. To do so, double-click your AlarmViewer and attribute values to the History Interval and Filter fields. You can also fill these fields with tags to let the user decide which filters to apply, as is the case in this solution example.

In this section:

Reference Information

See Alarms and Audit Trail for more information.