Closing Alarms with Historian Administrator

About Closing Alarms

The Close Alarms window provides the ability to close open alarms through Historian Administrator.

The Close Alarms window contains the following fields.

Field	Description
End Date/Time	Shows alarms that are open with an end date before the time specified.
Show Alarms button	Select to show alarms for the specified time period.
Alarm table	Displays any open alarms.
Close Alarms button	Closes selected alarms.

Closing an Alarm

Procedure

Open Historian Administrator.
Select Collectors.
From the list of collectors, select the alarms and events collector you wish to close alarms on.
Select the Close Alarms button. The Close Alarms window appears.
In the End Date/Time field, enter a date/time value. Selecting on the browse button brings up a calendar.
Select the Show Alarms button. A list of open alarms will appear.
Select the alarms you wish to close, and select the Close Alarms button.

Using the OPC AE Collector with FIX32 SCADA Collectors

At the moment no OPC Alarm & Event Server exists for use with FIX32 SCADA systems. To accommodate Alarm Collection from these systems, alarms can be proxied through an iFIX node with an OPC AE Server that the Proficy Historian OPC Alarm Collector can then receive them from.

There are two different configurations that can occur in this instance.

The first would be a simple proxy in which only one FIX32 system forwards its alarms through a particular iFIX node. In this situation (see Figure 1), the OPC AE Collector can be linked to the FIX32 Data collector (see Configure the OPC Alarms and Events Collector). With the link created, any Queries created with the Excel Add-In which compare Tag & Alarm data will function correctly.

Figure: OPC Collector Linked to FIX32 Data Collector

The second configuration (see Figure 2) consists of more than one FIX32 system proxying alarms through a single iFIX node. In this situation, the 'Link To Data Collector' property cannot be set to both FIX32 data collectors. As a result the area of the Alarm Archive responsible for creating the relationship between the alarm and tag data will not be populated and in turn the Excel Add-In will be unable to link the data.

Figure: FIX32 SCADA Proxying Through iFIX

To link alarm and tag data in this situation, an OLE DB query can be performed with a join between the "ItemID" column of the ihAlarms database and the "TagName" column of the ihRawData database. This join can only be performed if No Prefix has been added to the tagname. Below is an example of a parametrized query that uses the AlarmID property to find all values read from the corresponding tag for that alarm during the duration of the alarm.

SELECT   ihRawData.'Value', ihRawData.Tagname, ihRawData.'TimeStamp' 
FROM     ihRawData, ihAlarms
WHERE    ihRawData.Tagname = ihAlarms.ItemID
AND    ( ihRawData.'TimeStamp' >= ihAlarms.Starttime ) 
AND    ( ihRawData.'TimeStamp' <= ihAlarms.'Timestamp' ) 
AND    ( ihAlarms.AlarmID = 13240 )
AND    ( ihRawData.SamplingMode = 'RawByTime' )