vAgentConfiguration

Logs each alert sent out via email. Multiple rows per machine

Column Name

Type

Purpose

Machine_GroupID

varchar

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

agentGuid

numeric

A globally unique identifier for a machine ID.group ID account and its corresponding agent.

machName

varchar

Machine Name used for each agent

groupName

varchar

Group Name used for each agent

firstCheckin

datetime

timestamp recording the first time this agent checked into the system

lastCheckin

datetime

timestamp recording the most recent time this agent checked into the system

currentUser

varchar

login name of the currently logged in user. Blank if no one logged in at this time

lastLoginName

varchar

login name of the last user to log into this system

workgroupDomainType

tinyint

0 (or Null) = unknown
1 = not joined to either
2 = member of workgroup
3 = member of domain
4 = domain controller

workgroupDomainName

nvarchar

The name of the workgroup or domain

lastReboot

datetime

timestamp when this system was last rebooted

agentVersion

int

version number of agent installed on this system

contactName

varchar

User contact name assigned to this agent

contactEmail

varchar

User email address assigned to this agent

contactPhone

varchar

Contact phone number assigned to this agent

contactNotes

varchar

Notes associated with the contact information for this agent

enableTickets

int

0 if this user does not have access to ticketing through the user interface

enableRemoteControl

int

0 if this user does not have access to remote control through the user interface

enableChat

int

0 if this user does not have access to chat through the user interface

loginName

varchar

Login Name assigned to this user (if any) to access the system user portal interface.

credentialName

varchar

The username of the credential set for this agent (if any)

primaryKServer

varchar

address:port agent connects to for its primary kserver connection

secondaryKServer

varchar

address:port agent connects to for its secondary kserver connection

quickCheckinSecs

int

interval in seconds between quick checkins

agentTempDir

varchar

The temp directory used by the agent on this system