vAdminNotesLog

Notes each admin enters manually for a machine or group of machines. Entries in this log never expire.

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), null

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

AdminLogin

varchar(100), not null

Admin logon name. (note: no not name this col adminName)

EventTime

datetime(3), not null

Time stamp string representing the time the action took place. Default is CURRENT_TIMESTAMP so nothing needs to be entered here.

NoteDesc

varchar(2000), not null

description of the action