2.0

Table Of Contents
VMware ACE Administrator’s Manual
262 VMware, Inc.
eventCategory INTEGER, /* Event Category as defined in EventType */
eventType INTEGER, /* Event Type as defined in EventType */
sessionID VARCHAR(128), /* Ace Server Session ID */
clientIP VARCHAR(128), /* IP Address of the client machine (resvd) */
serverIP VARCHAR(128), /* IP Address of the Ace Server (reserved) */
turnaroundTime VARCHAR(21), /* Server-side execution time in ms */
handlerName VARCHAR(128), /* Name of the ClientLib handler (debug) */
returnCodeText VARCHAR(128), /* Text error code returned to the client */
messageParams VARCHAR(1024), /* Tab separated list of event data */
prevEventUID INTEGER UNIQUE, /* UID of the previous recorded event */
eventSignature VARCHAR(128), /* Event signature, signed with server key */
FOREIGN KEY(eventType) REFERENCES PolicyDb_EventType(eventType),
FOREIGN KEY(prevEventUID) REFERENCES PolicyDb_Event(eventUID),
PRIMARY KEY (eventUID));
Notethefollowingaboutthedatabaseschema:
Afewtableswithsysteminternalinformationandindicesarenotlisted.
BooleanvaluesarestoredasstringswithTRUEorFALSEvalue.
Timestampsarestoredasdecimal64bitnumberstringsshowingthenumberof
microsecondsfrom12:00AM01/01/1970.
Otherdates/timesarestoredasdecimalstringsshowingthenumberofseconds
from12:00AM01/01/1970.
ACE,Package,Instance,Access,andUserDatarecordsareneverdeletedfromthe
database,butrathermarkedasdeletedwiththedeletedfieldsettoTRUE,sothat
thepreviousinformationcanbeinspectedforauditpurposes.
TheguestandhostoperatingsystemportionsoftheACEpolicysetarestoredin
thePolicyDb_RuntimePolicytableinrespectivefieldsasstrings,iftheirlengthis
lessthan2000bytes.Ifthelengthofthepolicycomponentexceeds2000bytes,the
stringissplitin2000bytechunksandstored
inthePolicyDb_LongFieldtable.In
thiscase,thevaluefortherespectiveExtKeyfieldintheRuntimePolicytablewill
containtheforeignkeypointingtothecorrespondingseriesofstringsinthe
LongFieldtable(seethenotesinthetabledefinition).
Querying the Audit Event Log Data
IntheACEServerComponentitispossibletocreateanaudittrailforalltransactions
thatareperformedbytheserver.Thissystemcanbeusedbyadministratorstotrack
downusage,securitybreaches,policyerrors,performance,etc.
TheACEServerComponentEventLogginginfrastructureisflexibleenoughtoprovide
detailedloggingwhennecessary,withoutoverwhelmingthesystembycausinga
significantperformanceslowdownwheninoperation.