vAgentConfiguration
|
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 |
