Indexes in the EVENT_LOG 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 Event 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. |
|
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 EVENT_LOG.. |
