Database Details / Vocera Usage Data |
The deviceinfo table stores data about Vocera devices, such as badges. This table has a primary key based on the BadgeMacAddr column.
Column | Description |
---|---|
DeviceID |
varchar(20) default NULL Specifies the device ID from the Vocera Server. Example value: D-0009ef050686 |
BadgeMACAddr |
varchar(12) NOT NULL Specifies the badge MAC address. Example value: 0009ef006e9a |
SerialNo |
varchar(20) default NULL Specifies the badge serial number. |
Label |
varchar(30) default NULL Specifies the device label. |
Type |
varchar(15) default NULL Specifies the device type. Possible values: B1000A, B2000, B3000, MC70, or Smartphone. |
Color |
varchar(20) default NULL Specifies the device color. |
Owner |
varchar(50) default NULL Specifies the device Owner group. |
Site |
varchar(50) default NULL Specifies the device Site. |
TrackingDate |
date default NULL The tracking date of the device. Note: This field can be any date used to track a device, for example, the date it was sent for repair or RMA'ed. |
BadgeUsage |
tinyint(1) default NULL Indicates whether the badge is shared or nonshared. 1 = shared, 0 = nonshared. |
Notes |
text Notes describing the device. |
DeviceCode |
int(5) default '0' Specifies the badge device code. Possible values: -1 = B1000 badge, 0 = B1000A badge, 2 = B2000 badge Note: This is a legacy data field that is no longer used by standard Report Server reports. |
FirmwareVersion |
int(5) default '0' Specifies the badge firmware version. |
LastStatus |
varchar(50) default NULL Specifies the last status of the device. |
LastUser |
varchar(70) default NULL Specifies the last user of the device. |
LastLocation |
varchar(50) default NULL Specifies the last location of the device based on the access point it connected with. |
LastAccessed |
timestamp NULL default NULL The timestamp when the device last access the Vocera Server. |
InternalSerialNo |
varchar(20) default NULL The serial number provided by the device. This value can be used to validate the serial number entered by a user. |