vUptimeHistory
|
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). |
