vMonitorAlarmCounter

Listing of all alarms created by monitor counters.

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

0 -> Monitor Counter

MonitorName

varchar(100), not null

Name of monitor counter 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

AdminName

varchar(100), null

User who assigned monitor counter to machine