Table ALERT_HISTORY

MetaMiner alert history of alerts created, modified or fired.

 

Column Name

Data Type

Description

ALERT_CMS

varchar

The CMS associated to a CMS-based alert

ALERT_EVENT

nvarchar

The alert event (CREATED, MODIFIED, FIRED)

ALERT_EVENT_DATE

datetime

The date time of when a MetaMiner alert event took place

ALERT_EVENT_DATE_MILLIS

bigint

The date time in milliseconds of when a MetaMiner alert event took place

ALERT_EVENT_EMAILS

varchar

The email(s) attached to a MetaMiner alert (recipients of the alert output/status)

ALERT_EVENT_PHONES

varchar

The SMS phone number(s) attached to a MetaMiner alert (recipients of the alert output/status)

ALERT_EVENT_USER

nvarchar

The user who created the alert

ALERT_NAME

nvarchar

Name of the alert definition

ALERT_SERVER

varchar

Server associated to the alert for server-status based alerts

ALERT_UUID

varchar

The globally unique ID of an alert

ID

int

NOT USED

 

 

 
See also

MetaMiner Database Fields

 

© 2013-2015 by Infolytik