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

Group Name used for each agent

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 kserver connection

secondaryKServer

varchar(111), null

address:port agent connects to for its secondary kserver 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