deviceinfo

The deviceinfo table stores data about Vocera devices, such as badges. This table has a primary key based on the BadgeMacAddr column.

Table 1. deviceinfo table
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.