audit

The audit table stores data about changes made to the Vocera system. This table has a primary key based on the TxMillis column.

Table 1. audit table
Column Description
TxMillis

bigint(15) unsigned NOT NULL default '0'

The TxMillis column gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date and time of the event. See TxDateTime.

TxDateTime

datetime NOT NULL default '0000-00-00 00:00:00'

The TxDateTime column stores the date and time of an event, accurate to the second.

TxDate

date NOT NULL default '0000-00-00'

The TxDate column stores the date of an event, accurate to the day.

UserID

varchar(70) default NULL

The UserID column specifies the user ID of the person who made the change. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera server, unless the user logged in with the built-in login ID Administrator, in which case this value is __NONE__. Or, if the operation was performed automatically by the Vocera system, for example, an automated restore of the database, this value is null. See LoginId.

UserSite

varchar(50) NOT NULL default ''

In a multi-site installation, the UserSite column specifies the Vocera site with which the user is associated. In a single-site installation, this value is null.

LoginId

varchar(50) default NULL

The LoginId column specifies the login ID of the person who made the change. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera server, unless the user logged in with the built-in login ID Administrator, in which case this value is Administrator. See UserID.

Operation

varchar(30) NOT NULL default ''

The Operation column specifies the operation that changed the Vocera database. Sample values include: Backup, Update, Create, and Update Conference Group.

ModifiedEntityType

varchar(20) NOT NULL default ''

The ModifiedEntityType column specifies the type of the entity that was changed. Sample values include: AddrBook, Group, and User.

ModifiedEntityID

varchar(70) NOT NULL default ''

The ModifiedEntityID column identifies the entity that was changed. For a user, the value is the user ID. For a group, the value is the group name. For an address book entry, the value is the address book entry name. If the Vocera database was not changed, for example, when a Backup operation occurs, this value is __NONE__.