|
|
|
|
vAgentConfiguration |
Logs each alert sent out via email. Multiple rows per machine |
|
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), not 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. |
firstCheckin |
datetime(3), null |
timestamp recording the first time this agent checked into the system |
lastCheckin |
datetime(3), null |
timestamp recording the most recent time this agent checked into the system |
currentUser |
varchar(100), null |
login name of the currently logged in user. Blank if no one logged in at this time |
lastLoginName |
varchar(100), not null |
login name of the last user to log into this system |
workgroupDomainType |
tinyint(3), not null |
0 (or Null) = unknown 1 = not joined to either 2 = member of workgroup 3 = member of domain 4 = domain controller |
workgroupDomainName |
nvarchar(32), null |
The name of the workgroup or domain |
lastReboot |
datetime(3), null |
timestamp when this system was last rebooted |
agentVersion |
int(10), null |
version number of agent installed on this system |
contactName |
varchar(100), null |
User contact name assigned to this agent |
contactEmail |
varchar(100), null |
User email address assigned to this agent |
contactPhone |
varchar(100), null |
Contact phone number assigned to this agent |
contactNotes |
varchar(1000), null |
Notes associated with the contact information for this agent |
enableTickets |
int(10), not null |
0 if this user does not have access to ticketing through the user interface |
enableRemoteControl |
int(10), not null |
0 if this user does not have access to remote control through the user interface |
enableChat |
int(10), not null |
0 if this user does not have access to chat through the user interface |
loginName |
varchar(100), not null |
Login Name assigned to this user (if any) to access the system user portal interface. |
credentialName |
varchar(100), not null |
The username of the credential set for this agent (if any) |
primaryKServer |
varchar(111), null |
address:port agent connects to for its primary Kaseya Server connection |
secondaryKServer |
varchar(111), null |
address:port agent connects to for its secondary Kaseya Server connection |
quickCheckinSecs |
int(10), null |
interval in seconds between quick checkins |
agentTempDir |
varchar(200), null |
The working directory used by the agent on this system |