Integration

Table 2‑2. Schema for the event and event_historical Tables (Continued)
Column Name Oracle Data Type SQL Server Data Type Description
LUNId NVARCHAR2(512) nvarchar(512) ID of the LUN that stores the associated
object.
MachineId NVARCHAR2(512) nvarchar(512) ID of the associated physical or virtual
machine.
Module NVARCHAR2(512) nvarchar(512) View component that raised the event. For
example, Admin, Broker, Tunnel,
Framework, Client, or Agent.
ModuleAndEventText NVARCHAR2(512) nvarchar(512) Event message with values substituted for
attribute parameters.
Node NVARCHAR2(512) nvarchar(512) Name of the virtual device node.
Severity NVARCHAR2(512) nvarchar(512) Severity level. For example, INFO,
WARNING, ERROR, AUDIT_SUCCESS,
AUDIT_FAIL.
Source NVARCHAR2(512) nvarchar(512) Identifier for the source of the event.
ThinAppId NVARCHAR2(512) nvarchar(512) ID of the associated ThinApp™ object.
Time TIMESTAMP datetime Time at which the event occurred,
measured from the epoch (January 1,
1970).
UserDiskPathId NVARCHAR2(512) nvarchar(512) ID of the user disk.
UserSID NVARCHAR2(512) nvarchar(512) SID of the associated user in Active
Directory.
The following table shows the schema for the event_data and event_data_historical database tables.
Table 2‑3. Schema for the event_data and event_data_historical Tables
Column Name Oracle Data Type SQL Server Data Type Description
BooleanValue SMALLINT tinyint Value of a Boolean attribute.
n
0 = false
n
1 = true
EventID INTEGER int Unique primary key for the event.
IntValue INTEGER int Value of an integer attribute.
Name NVARCHAR2(512) nvarchar(512) Attribute name (for example,
UserDisplayName).
StrValue NVARCHAR2(512) nvarchar(512) Value of a string attribute. For other types
of attributes, this column contains an
interpretation of the data type as a string.
View Integration
VMware, Inc. 9