|
|
|
|
vMonitorAlarmService |
Listing of all of the alarms created by monitor services. |
|
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 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 |
0 -> Monitor Service |
MonitorName |
varchar(100), not null |
Name of monitor service 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, 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 |
MonitorAlarmState |
smallint(5), null |
0 -> Stopped 1 -> Running |
AdminName |
varchar(100), null |
User who assigned monitor service to machine |