vMonitorAlarmAlert

Listing of all alarms created by monitor alerts.

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

Organization, then machine group the machine is assigned to.

MonitorAlarmID

int(10), not null

unique monitor alarm number

MonitorType

tinyint(3), not null

4 -> Monitor alert

EventLogType

int(10), null

Only applies to AlertType=6 (NT Event Log)

0 -> Application Event Log

1 -> System Event Log

2 -> Security Event Log

AlarmType

smallint(5), null

0 -> Alarm

1 -> Trending

AlertType

int(10), not null

Alerts are one of several monitor types.
1 - Admin account disabled
2 - Get File change alert
3 - New Agent checked in for the first time
4 - Application has been installed or deleted
5 - Agent Procedure failure detected
6 - NT Event Log error detected
7 - Kaseya Server stopped
8 - Protection violation detected.
9 - PCI configuration has been changed
10 - Disk drive configuration change
11 - RAM size changed.
12 - Test email sent by serverInfo.asp
13 - Scheduled report completed
14 - Network scan alert type
15 - agent offline
16 - low on disk space
17 - disabled remote control
18 - agent online
19 - new patch found
20 - patch path missing
21 - patch install failed
23 - Backup Alert

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

MonitorAlarmState

smallint(5), null

0 -> Stopped

1 -> Running

AdminName

varchar(100), null

User who assigned monitor alert to machine