2.0

Table Of Contents
VMware, Inc. 265
Appendix: Using the VMware ACE 2 Management Server Database Schema and Querying the Audit Event Log Data
MessageParameters(tabseparatedlist;seebelow)
PreviouseventUUIDtopreventunauthorizedrecorddeletionorinsertion(log
integrity)
Eventrecordhashwithaserverkeytorevealmodificationoftherecord(log
integrity)
ACE,package,andinstanceUIDsandpolicyversionprovide“coordinates”ofthelog
eventinthespaceofACEServerobjects.Theyhelptoidentifytheeventwiththestate
ofthesystem.ByusingdatabasequerytoolssuchasCrystalReports,theadministrator
can,forexample,findallACEadministration
eventsthataffectedaparticularACE,
fromitsmomentofcreationuntilitwasdeleted(sinceweneverdeleteobjectsfromthe
database,butrathermarkthemasdeleted).
Notallcoordinateshavetobepresentforallevents.Forinstance,ifapackage
expirationdateupdateislogged,the
instanceUIDfieldisnotset,sinceallinstances
withinthepackagewillbeaffected.
Ifthedatainthelogeventisstoredpermanentlyelsewhereinthedatabaseanditis
immutable,itisnotduplicatedinthelogentry.Forexample,whenanewpolicygets
published,wedo
notincludethecompletepolicytextinthelogentry,butrather
referenceitsversionnumber,sothatthecompletedataoftheeventcanbe
reconstructedfromPolicyDb_RuntimePolicyandPolicyDb_Accesstablesifnecessary.
TheeventtypecodeisassociatedwithalookuptablePolicyDb_EventType,which
containsatext
messagetemplateforeachtypeofevent,category,andloglevelofthe
event.Themessagemaycontainparameterplaceholders%s,inwhichcasethemessage
parametersfieldinthelogentrywillcontaina(tabdelimited)listofvaluesforthese
parameters.Forexample,aninstanceadministrationeventwith
type=4110willhave
themessage
4110 -> "Instance Set Guest Info requested, IP address = %s, MAC
address %s, configuration message \"%s\", machine name \"%s\",
configuration status %s"
AndtheMessageParametersfieldwillshow
10.17.0.3 00:0C:29:1A:2B:3C OK ACETest 0
Theresultingparametersshouldreplacethe%splaceholdersinthemessagetemplate.
N
OTEACEServerdoesnotlogsensitivedatalikepasswordsorencryptionkeys.