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
*This data type is required for Microsoft SQL Server.
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.

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.