lostconnectionlog

The lostconnectionlog table stores summary information about badges that have lost their connection with the Vocera server, connected to an access point, or searched for a DHCP server. This table has a primary key based on the TxMillis column. For details about each record, go to the lostConnectiondetail table with lostConnectiondetail.txParentMillis = lostconnectionlog.TxMillis.

Table 1. lostconnectionlog table
Column Description
TxMillis

bigint(15) unsigned NOT NULL

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 last person logged into the badge. 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__. 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.

BadgeMacAddress

varchar(12) default NULL

The BadgeMACAddr specifies the badge MAC address. Example value: 0009ef006e9a

BadgeBinary

text

Raw binary log sent by the badge.

SFAPCount

smallint(6) NOT NULL default '0'

Number of times the user's badge went searching for an access point.

CAPCount

smallint(6) default NULL

Number of times the user's badge attempted to connect and authenticate at the access point.

LSCount

smallint(6) default NULL

Number of times the user's badge lost the Vocera server connection.

SFSCount

smallint(6) NOT NULL default '0'

Number of times the user's badge was searching for a Vocera server.

SFDHCPCount

smallint(6) NOT NULL default '0'

Number of times the user's badge was searching for a DCHP server.

Duration

smallint(6) NOT NULL

The Duration column specifies the duration of the lost connection, in seconds.