Alarm Audit table
- Last UpdatedApr 24, 2025
- 3 minute read
The Historical Alarm Audit (almaudit) table audits alarms and their acknowledgment by Controllers and/or applications. The table is part of the Event database in the historical Microsoft SQL Server.
When AVEVA Enterprise SCADA generates an alarm, the AlarmSerialization program records the alarm in both the almaudit table and the RealTime database (RTDB) almsum table. Similarly, when a Controller acknowledges an alarm, the AlarmSerialization program writes the alarm acknowledgement to the almaudit table, in addition to updating the almsum table. Similarly, when a Controller acknowledges an alarm, the AlarmSerialization program writes the alarm acknowledgement to the almaudit table and updates the almsum table.
Auditors can use the Historical record in the almaudit table to examine the frequency and details of alarms seen by Controllers at any given time. While the almaudit table is similar to the OperActivitySummary table, the former contains only the actual alarms generated and acknowledged. Since the events and alarms may be inhibited separately for a given telemetered point or application-related alarm, in reality a Controller may only see an event for an alarm while the alarm itself is inhibited. By examining the contents of the almaudit table, an auditor can focus only on the alarms that were shown to the Controller and the actions taken to acknowledge the alarms.
|
Internal Field |
Data Type |
Description |
|---|---|---|
|
time |
GMTtime |
This field indicates—in Greenwich Mean Time (GMT)—either the time of the alarm, or the time of the action taken against the alarm. |
|
msec |
int |
This field indicates the millisecond section of the time. |
|
offset |
GMToffset |
The difference (in minutes) between local time and Coordinated Universal Time (UTC) when the time field was populated. |
|
type |
nameType |
This field indicates the type of the alarm. An alarm is one of the following types:
|
|
host |
nameType |
This field indicates the name of the host associated with the alarm. |
|
process |
nameType |
This field indicates the name of the application or process associated with the alarm. |
|
dbName |
nameType |
This field indicates the name of the database associated with the alarm. |
|
ptName |
nameType |
This field indicates the name of the point associated with the alarm. |
|
description |
descType |
This field provides a description of the ptName. |
|
rtuName |
nameType |
This field indicates the name of the Remote Terminal Unit (RTU) associated with the alarm. |
|
groupName |
nameType |
This field indicates the name of the group to which the ptName belongs. Some alarms are not associated with a group (such as, for example, a service restart or mode switch). |
|
message |
msgType |
This field indicates either the text used for the alarm message, or the command issued against the alarm. |
|
fgInt |
tinyint |
This field indicates the foreground color used for the alarm’s message. |
|
sevInt |
tinyint |
This field indicates the severity associated with the alarm. |
|
key1 |
int |
This field is related to Datapump support (for internal use only). |
|
key2 |
int |
This field is related to Datapump support (for internal use only). |
|
spooler |
tinyint |
This field indicates the spooler number associated with groupName. |
|
hasNote |
boolType |
This field is reserved for future enhancement. |
|
datasetId |
tagIDType |
This field indicates the ID of the associated dataset. |
|
ownSysId |
tagIDType |
This field indicates the system ID of the system that owns the alarm. |
|
fldname |
nameType |
When used, this field indicates the name of the specific field that is in alarm. |
|
category |
nameType |
This field indicates the category associated with the alarm. |
|
areaName |
nameType |
This field is reserved for future enhancement. |
|
annunciated |
nameType |
This field indicates whether or not the alarm was flashing to the Controller. |
|
inalarm |
nameType |
This field indicates whether or not the alarm was persistent. |
|
timestampstr |
nameType |
This field is a string representation of the time field. |
|
covered |
nameType |
This field indicates whether the alarm was covered by Area Of Responsibility (AOR). |
|
purgetimer |
tinyint |
This field indicates the purge timer value of the alarm in seconds. |
|
stationName |
nameType |
This field indicates the RealTime station associated with the alarm. |
|
paging_code |
nameType |
This field indicates the paging code associated with the alarm for pre-parking. |
|
condition |
nameType |
This field indicates the safety condition associated with the alarm. Possible values are as follows:
|
|
tag |
nameType |
This field indicates the flag.tag field of the point in alarm. |
|
alarmGUID |
nchar(40) |
The field is used to indicate a relation between different alarms. For further information, refer to the "Understanding Alarm Stories" section below. |
|
alarmAuditType |
tinyint |
This field references the audit type of the alarm. For further information, refer to the "Understanding Alarm Stories" section below. |