vAgentLabel

Identifies the status of agents. Used for display purposes.

Column Name

Type

Purpose

displayName

varchar(201), null

The name of the machine ID.group name.

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.

agentGuidStr

varchar(26), null

A string version of agentGuid. Some languages convert the large number numeric to exponential notation. This string conversion prevents that.

online

int(10), null

0 -> offline

1 -> online

2 -> online and user has not used the mouse or keyboard for 10 minutes or more.

198 -> account suspended

199 -> agent never checked in (template account)

transitionTime

datetime(3), null

Applies when online is either 0 or 2.

• When online is 0, the time at which the Agent last checked in.
• When online is 2, the time when the machine was deemed idle (10 minutes after the last mouse or keyboard entry).

timezoneOffset

int(10), null

The timezone offset for the agent as compared to universal time.

currentLogin

varchar(100), null

The login name of the current user.

toolTipNotes

varchar(1000), not null

The tooltip text displayed for a machine ID.

showToolTip

tinyint(3), not null

0 -> Do not show machine ID tool tips.

1 -> Do show tool machine ID tool tips.

agntTyp

int(10), not null

0 -> windows agent

4 -> mac agent

5 -> linux agent

agentOnlineStatus

int(10), null