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

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

AdminAdmin

varchar

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

EventTime

datetime

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

NoteDesc

varchar

description of the action