vMonitorAlarmSystemCheck

Listing of all alarms created by monitor system checks.

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

Organization, then machine group the machine is assigned to.

MonitorAlarmID

int(10), not null

unique monitor alarm number

MonitorType

tinyint(3), not null

5 -> Monitor system check

SystemCheckType

int(10), null

1 -> Web Server

2 -> DNS Server

4 -> Port Connection

5 -> Ping

6 -> Custom

AlarmType

smallint(5), null

0 -> Alarm

1 -> Trending

Parameter1

varchar(1000), null

First parameter used in system check

Parameter2

varchar(1000), null

(Optional) Second parameter used by system check

Message

varchar(3000), null

Message created from alarm, email message body

AlertSubject

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

MonitorAlarmState

smallint(5), null

0 -> Stopped

1 -> Running

AdminName

varchar(100), null

User who assigned of monitor counter to machine