vMonitorAlarmService

Listing of all of the alarms created by monitor services.

Column Name

Type

Purpose

MonitorAlarmID

int

unique monitor alarm number

Machine_GroupID

varchar

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

MachineName

varchar

Machine Name used for each agent

MonitorType

int

0 -> Monitor Service

MonitorName

varchar

Name of monitor service object

AlarmType

int

0 -> Alarm

1 -> Trending

AlarmState

smallint

1 -> Open

2 -> Closed

Note

varchar

Notes administrator has entered on the alarm

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