vMonitorAlarmSNMP

Listing of all alarms created by monitor SNMP Get objects.

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

3 -> Monitor SNMP Get

MonitorName

varchar(100), not null

Name of monitor SNMP Get 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, if the return value of the SNMP Object Get command is a string the value will be the the Message

SNMPName

varchar(50), null

Name returned from SNMP Device on scan

SNMPCustomName

varchar(100), null

Custom name for SNMP Device

AdminName

varchar(100), null

User who assigned monitor SNMP Get to machine