failures

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
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.

TxDate

date default NULL

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

TxDateTime

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.

UserID

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__.

UserSite

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.

BadgeMACAddr

varchar(12) default NULL

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

Failuretext

varchar(50) NOT NULL default ''

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