vNtEventLog

Event log data collected from each managed 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), 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

Organization, then machine group the machine is assigned to.

logType

int(10), null

1 -> Application Log

2 -> Security Log

3 -> System Log

eventType

int(10), null

1 -> Error

2 -> Warning

4 -> Informational

8 -> Success Audit

16 -> Failure Audit

eventTime

datetime(3), null

Time the event occurred

ApplicationName

nvarchar(200), null

event log source

EventCategory

nvarchar(200), null

event log category

eventId

int(10), null

event log event ID

username

nvarchar(200), null

event log user

computerName

nvarchar(200), null

event log computer name

EventMessage

nvarchar(2000), null

event log message