Indexes, Columns and Rows in EM_LOG Tables

Indexes in EM 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 EM 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.

time

string

 

event_type

string

The type of Event Manager event associated with the event source.

event_source

string

Identifier that triggered the event.

action_type

string

The type of Event Manager action associated with the action source.

action_target

string

Identifier of the action's target.

 

 

 

Optional fields

 

 

project

string

Name of the CIMPLICITY project.

msec

number

Actual number of milliseconds in the timestamp.

More information

image\Buttongraysm.png

Event Management logging.