Indexes, Columns, Rows in the ALARM

Indexes in Alarm logging tables include a:

Primary key index on the joined timestamp and sequence number columns.

Secondary key index on the joined timestamp_utc and sequence number columns.

Secondary index on the timestamp alone.

Secondary index on the timestamp_utc alone.

If you have selected the project name table attribute, the primary key index also includes the project name column.

The primary key includes an MSEC column, if milliseconds is enabled.

Columns and rows in Alarm logging tables are as follows:

Column Name	Data Type	Description
Constant fields
timestamp	date/time	Timestamp of the logging event.
timestamp_utc	date/time	UTC timestamp of the logging event.
sequence_number	number	Identity column to ensure uniqueness.
alarm_id	string	CIMPLICITY alarm identifier.
alarm_class	string	CIMPLICITY alarm class associated with the alarm.
resource	string	CIMPLICITY resource associated with the alarm.
logged_by	string	CIMPLICITY process that logged the alarm.
reference	string	Reference information for the alarm logged.
prev_state	string	Previous state of the alarm. Possible values.
		N	Normal
		G	Generate
		R	Reset
		A	Acknowledge
		D	Delete
log_action	string		State of the alarm that caused log event. Possible values.
		N	Normal
		G	Generate
		R	Reset
		A	Acknowledge
		D	Delete
final_state	string		Final state of the alarm. Possible values N=G=R=A= D=
		N	Normal
		G	Generate
		R	Reset
		A	Acknowledge
		D	Delete
alarm_message	string	Message associated with the alarm.
generation_time	date/time	Timestamp the alarm was generated.
Optional fields
project	string	Name of the CIMPLICITY project.
msec	number	Actual number of milliseconds in the timestamp.

System alarms in the ALARM_LOG.