vAlertLog

Logs each alert sent out via email. Multiple rows per machine

Column Name

Type

Purpose

Machine_GroupID

varchar

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

agentGuid

numeric

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

machName

varchar

Machine Name used for each agent

groupName

varchar

Group Name used for each agent

EventTime

datetime

time stamp when the event was recorded

AlertEmail

varchar

email address to send the alert to

AlertType

int

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 -> Script failure detected

6 -> NT Event Log error detected

7 -> KServer 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 -> LAN Watch 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

EmailSubject

varchar

Email subject line

EmailBody

varchar

Email body