Download the Solution Example Here: AlarmHistoryFilter.dbsln
Solution Name: AlarmHistoryFilter
Software Version: 10.1
Summary
This example shows how to filter AlarmHistory data using start and end dates and SQL statements as filters.
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: