The failures table stores data about badge software failures. This table has a primary key based on the TxMillis column.

Table 1. failures table
Column Description

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.


date default NULL

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


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

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


varchar(70) default NULL

The UserID column specifies the user ID of the badge user, if a user was logged in to the badge. If no user was logged in to the badge at the time of the failure, this value is the literal string __NLI__.


varchar(50) default NULL

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


varchar(12) default NULL

The BadgeMACAddr column specifies the badge's MAC address. Example value: 0009ef0078a3


varchar(50) NOT NULL default ''

The Failuretext column stores text describing the failure. Example value: Failure in pre.c at line 166. Code: 0009