2.0

Table Of Contents
VMware, Inc. 259
Appendix: Using the VMware ACE 2 Management Server Database Schema and Querying the Audit Event Log Data
identityData VARCHAR(128), /* Internal representation, SID in AD */
/* case, token value goes here. */
accVersion INTEGER NOT NULL, /* Access object version number */
identityType INTEGER NOT NULL, /* AD User, Group, or Token Value */
identityName VARCHAR(128), /* UI visible user/group name in AD case */
accUseInstanceLimit VARCHAR(7)
DEFAULT 'FALSE' NOT NULL, /* Limit number of instances for this ID? */
accInstanceLimit INTEGER NOT NULL, /* Max no. of ACE instances allowed */
accTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
accTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */
PRIMARY KEY(accessPK),
FOREIGN KEY(aceUID) REFERENCES PolicyDb_Ace(aceUID));
/* ACE Instance object data */
CREATE TABLE PolicyDb_Instance (
instanceUID VARCHAR(128), /* VM instance ID (primary key) */
packageUID VARCHAR(128) NOT NULL, /* The package it belongs to. */
aceUID VARCHAR(128) DEFAULT '' NOT NULL, /* The ACE Master it belongs to */
creatorIdName VARCHAR(128) NOT NULL, /* Display name of the activator user */
creatorIdData VARCHAR(256), /* Fully qualified name of the activator */
creatorAuthType INTEGER NOT NULL, /* The type of access check at activation */
activationDate VARCHAR(21) NOT NULL, /* The date and time for the activation. */
lastPolicyCheck VARCHAR(21) NOT NULL, /* Last time when the player called server */
revocationDate VARCHAR(21) NOT NULL, /* When the instance was revoked */
replacementDate VARCHAR(21) NOT NULL, /* When replaced because of Copy Protect. */
/* policy */
inheritsExpiration
VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Use expiration info from Ace Policy
Set */
insUseValidDates
VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Use validity dates or always valid */
insValidDateStart VARCHAR(21) NOT NULL, /* The instance is valid from this date*/
insValidDateEnd VARCHAR(21) NOT NULL, /* The instance is valid till this date*/
insPassword VARCHAR(128), /* The login password for non-AD */
/* authentication for this instance */
hostName VARCHAR(128), /* The name of the host PC the VM runs on */
hostIp VARCHAR(128), /* The IP addr of the host the VM runs on */
insProtectionKey VARCHAR(1024), /* Instance VM disk encryption key */
copyProtectionId VARCHAR(1024), /* Stores location of the copy */
insPreview VARCHAR(7) DEFAULT 'FALSE' NOT NULL, /* Is preview instance */
guestIpAddress VARCHAR(128) DEFAULT '', /* Reported VM IP address */
guestMacAddress VARCHAR(128) DEFAULT '', /* Assigned VM MAC address */
guestMachineName VARCHAR(128) DEFAULT '', /* The guest (VM) OS host name */
guestConfigStatus INTEGER DEFAULT 0, /* The completion status of guest */
/* auto-configuration */
guestConfigMsg VARCHAR(512), /* Message for the guest auto-config */
insTsCreated VARCHAR(21) DEFAULT 0 NOT NULL, /* Creation timestamp */
insTsLastModified VARCHAR(21) DEFAULT 0 NOT NULL, /* Last modified timestamp */
deleted VARCHAR(7) DEFAULT 'FALSE', /* Is this entry deleted (tombstone) */