vUptimeHistory

Data collected for the uptime history report. Use in conjunction with the getMachUptime web service

Column Name

Type

Purpose

Machine_GroupID

varchar(201), null

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

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.

machName

varchar(100), null

Machine Name used for each agent

groupName

varchar(100), null

Organization, then machine group the machine is assigned to.

eventTime

datetime(3), null

timestamp of the beginning of the time segment

duration

int(10), null

Number of seconds this time segment lasted

type

int(10), null

1 – Agent on but cannot connect to Kaseya Server

2 – Agent on and connected to Kaseya Server

3 – Agent off normally

4 – Abnormal agent termination

5 – Agent alarms suspended (do not count supended time when computing total uptime (function getMachUptime)

6 – Suspend ended

loginName

varchar(100), null

Name of the user logged on during this time segment. (SYSTEM if no one was logged on).