vMonitorAlarmProcess

Listing of all alarms created by monitor processes.

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

A concatenated representation of the machine id and the group id it is associated with

agentGuid

numeric(26,0), null

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

MachineName

varchar(100), null

Machine Name used for each agent

GroupName

varchar(100), null

Group Name used for each agent

MonitorAlarmID

int(10), not null

unique monitor alarm number

MonitorType

tinyint(3), not null

2 -> Monitor Process

MonitorName

varchar(100), not null

Name of monitor process object

AlarmType

smallint(5), null

0 -> Alarm

1 -> Trending

Message

varchar(3000), null

Message created from alarm, email message body

AlarmSubject

varchar(500), null

Subject of alarm and email subject

AlarmEmail

varchar(1000), null

Email Address(es) alarm is sent to

EventTime

datetime(3), not null

Date and Time of alarm

TicketID

varchar(30), null

Ticket ID created from alarm

LogValue

float(53), null

Value causing alarm, below are process values:

AdminName

varchar(100), null

0 -> Stopped

1 -> Running