Database Details / Vocera Usage Data |
The loginlogout table stores information about when Vocera devices logged in and logged out. This table has a primary key based on the TxMillis column.
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 person who logged in or logged out. This value corresponds to a User ID specified via the Administration Console or the User Console on the Vocera Server. |
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. |
Operation |
varchar(64) NOT NULL default '' Specifies the operation, either login or logout. |
DeviceMACAddr |
varchar(12) NOT NULL default '' Specifies the device MAC address. Example value: 0009ef006e9a |
APMACAddr |
varchar(12) default '' Specifies the MAC address of the wireless access point with which the device was most recently associated. Example value: 000f24e9dce0 |
LoginUserCount |
int(11) default null The current number of users that are logged in immediately following the Login or Logout operation. |
TotalLic |
int(11) default null The total number of users login licenses. |