Event manager
The following tables deal with information related to creating and managing events.
ALERT
This table contains all the alerts that MVE supports.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key |
|
NAME |
VARCHAR(255) |
The textual name of the alert. For example, “Supply Alert.” |
|
SEVERITY |
VARCHAR(255) |
For example, “ERROR.” |
|
CATEGORY |
VARCHAR(255) |
For example, “SUPPLIES.” |
ASSIGNED_EVENTS
This table links events with their assigned Configuration Items.
|
Field name |
Data type |
Description |
|---|---|---|
|
CI_ID |
BIGINT |
The composite primary key. Refers to CONFIG_ITEM.CI_ID. |
|
EVENT_ID |
BIGINT |
The composite primary key. Refers to EVENT.EVENT_ID. |
|
EVENT_REGISTRATION_STATE |
VARCHAR(255) |
The options are REGISTERED and NOT_REGISTERED. |
DESTINATION
This table represents an action within the Event Manager module.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
DESTINATION_TYPE |
VARCHAR(31) |
The type of destination, currently either email or shell command. Depending on the type, not all columns apply. |
|
NAME |
VARCHAR(255) |
The user-supplied name of the destination. |
|
EMAIL_BODY |
VARCHAR(255) |
The email body text. |
|
EMAIL_CC |
VARCHAR(255) |
The email CC list. |
|
EMAIL_FROM |
VARCHAR(255) |
The email From text. |
|
EMAIL_SUBJECT |
VARCHAR(255) |
The email Subject text. |
|
EMAIL_TO |
VARCHAR(255) |
The email to text. |
|
COMMAND_PATH |
VARCHAR(255) |
The full path to the command. |
|
COMMAND_PARAMS |
VARCHAR(255) |
Any parameters to send to the command. |
|
DESCRIPTION |
VARCHAR(4000) |
An optional user description of the action. |
|
LAST_MODIFIED |
Timestamp |
The date of the last edit of the action. |
EVENT
This table contains user-created events, which consist of a name, a description, and a collection of alerts to include.
|
Field name |
Data type |
Description |
|---|---|---|
|
NAME |
VARCHAR(255) |
The user-supplied name of the event. |
|
DESCRIPTION |
VARCHAR(255) |
The user-supplied description of the event. |
|
EVENT_ID |
BIGINT |
The primary key. |
|
TRIGGER_DESTINATIONS |
VARCHAR(255) |
The trigger destinations of the event. The options are on_active_only and on_active_and_clear. |
|
GRACE_PERIOD_ENABLED |
SMALLINT/ TINYINT* |
The flag indicating whether a grace period is enabled. |
|
GRACE_PERIOD_MINUTES |
INTEGER |
The number of minutes for the grace period. |
|
LAST_MODIFIED |
TIMESTAMP |
The time of the last edit of the event. |
*This data type is required for Microsoft SQL Server.
EVENT_ALERTS
This table links an event to the collection of alerts it includes.
|
Field name |
Data type |
Description |
|---|---|---|
|
EVENT_ID |
BIGINT |
The composite primary key. Refers to EVENT.EVENT_ID. |
|
ALERT_ID |
BIGINT |
The composite primary key. Refers to ALERT.ALERT_ID. |
EVENT_DESTINATIONS
This table links an event to an associated action.
|
Field name |
Data type |
Description |
|---|---|---|
|
EVENT_ID |
BIGINT |
The composite primary key. Refers to EVENT.EVENT_ID. |
|
DESTINATION_ID |
BIGINT |
The composite primary key. Refers to DESTINATION.DESTINATION_ID. |
PRINTER_EVENT_ACTIVE_CONDITIONS
This table represents the active conditions or alerts for printers with events that trigger that condition or alert. Multiple conditions have their corresponding rows, all pointing to the same PRINTER_ID.
|
Field name |
Data type |
Description |
|---|---|---|
|
ACTIVE_CONDITION_ID |
BIGINT |
The primary key. |
|
LOCATION |
VARCHAR(255) |
For example, “Tray 1.” |
|
MESSAGE |
VARCHAR(255) |
For example, “Tray Missing.” |
|
TYPE |
VARCHAR(255) |
For example, “Intervention Required.” |
|
CI_ID |
BIGINT |
Refers to CONFIG_ITEM.ID. |
|
DESTINATION_TASK_ID |
VARCHAR(80) |
The foreign key back to SYSTEM_LOG.TASK_ID. |