2.0

Table Of Contents
VMware, Inc. 261
Appendix: Using the VMware ACE 2 Management Server Database Schema and Querying the Audit Event Log Data
hostPolicyDataExtKey VARCHAR(128), /* If too long store in LongField table */
expirationType INTEGER NOT NULL, /* Expiration Type (enum) */
expValue_1 VARCHAR(21) NOT NULL, /* Expiration value (depends on type) */
expValue_2 VARCHAR(21) NOT NULL, /* Expiration value (depends on type) */
cacheLifetime VARCHAR(21) NOT NULL, /* How long could work without server */
rtpInstType INTEGER NOT NULL, /* Instantiation authentication check type */
rtpAuthType INTEGER NOT NULL, /* Runtime authentication check type */
rtpUseInstanceLimit VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Limit number of instances for this ACE? */
rtpInstanceLimit INTEGER NOT NULL, /* Max no. of ACE instances allowed */
rtpUsePerUserInstanceLimit VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Limit number of instances per user? */
rtpPerUserInstanceLimit INTEGER NOT NULL, /* Max no. of ACE instances per user */
copyPolicy INTEGER DEFAULT 0 NOT NULL, /* Behavior if VM instance is copied */
published VARCHAR(7) DEFAULT 'FALSE' NOT NULL,/* Policy published (update locked)*/
rtpTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
rtpTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY (aceUID, policyVersion),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* ACE Management Server info - reserved for future use */
CREATE TABLE PolicyDb_AcescServer (
serverHostname VARCHAR(128), /* Host name of the server computer */
serverPort INTEGER, /* TCP port number server is listening on */
secure VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Whether HTTPS is enabled */
sslCertificateExtKey VARCHAR(128), /* SSL Certificate data, key to stored */
/* in LongField table */
sslCertificateChainExtKey VARCHAR(128), /* SSL Certificate Chain data, key to */
/* stored in LongField table */
PRIMARY KEY (serverHostname, serverPort));
/* Audit Event Log Event Types lookup table */
CREATE TABLE PolicyDb_EventType (
eventType INTEGER, /* Event Type code (PK) */
eventMessage VARCHAR(1024), /* Printable message for this event type */
eventCategory INTEGER, /* Event Category code */
eventCategoryName VARCHAR(128), /* Event Category printable name */
eventLogLevel INTEGER, /* Event Log Level */
PRIMARY KEY (eventType));
/* Audit Event Log data */
CREATE TABLE PolicyDb_Event (
eventUID INTEGER, /* Primary key of the table (sequential) */
eventTs VARCHAR(21), /* Timestamp of the event creation in uSec */
loginName VARCHAR(128), /* Login user name of the actor */
aceUID VARCHAR(128), /* UID of the ACE affected by event */
packageUID VARCHAR(128), /* UID of the package affected by event */
instanceUID VARCHAR(128), /* UID of the instance affected by event */
policyVersion INTEGER, /* Version of ACE policy affected by event */