vMonitorAlarmService

Listing of all of the alarms created by monitor services.

Column Name

Type

Purpose

Machine_GroupID

varchar

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

agentGuid

numeric

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

MachineName

varchar

Machine Name used for each agent

GroupName

varchar

Group Name used for each agent

MonitorAlarmID

int

unique monitor alarm number

MonitorType

tinyint

0 -> Monitor Service

MonitorName

varchar

Name of monitor service object

AlarmType

smallint

0 -> Alarm

1 -> Trending

Message

varchar

Message created from alarm, email message body

AlarmSubject

varchar

Subject of alarm and email subject

AlarmEmail

varchar

Email Address(es) alarm is sent to

EventTime

datetime

Date and Time of alarm

TicketID

int

Ticket ID created from alarm

LogValue

float

Value causing alarm, below are service values:

-1 -> Does not exist

0  -> Reserved

1  -> Stopped

2  -> Start Pending

3  -> Stop Pending

4  -> Running

5  -> Continue Pending

6  -> Pause Pending

7  -> Paused

AdminName

varchar

Administrator who assigned  monitor service to machine