summarydeviceactivity

This summary table lists the latest device activity on a per-day basis.

Table 1. summarydeviceactivity table
Column	Description	Example
txDate	`date` The date of the aggregated data.	`2016-10-21`
DeviceId	`varchar` Displays the device id.	`0009ee13a7d8`
DeviceType	`varchar` Displays the device type (for example: Badge, iOS, Android).	`Badge`
DeviceVersion	`varchar` Displays the device version (for example, B3000, Apple VCS, Android VCS).	`B3000N`
Site	`varchar` Displays the site where the device was used.	`MySiteName`
DeviceSite	`varchar` Displays the home site for the device.	`MyDeviceSiteName`
DeviceSerialNo	`varchar` Displays the device serial number.	`G5DH2313A6D8`
FinishedAt	`timestamp NULL DEFAULT NULL` Displays the timestamp for when the activity was finished.	`2016-10-21 16:35:13`
AccessPoint	`varchar` Displays the access point for the device.	`b414895bad32`
Location	`varchar` Displays the device location.	`Product Management`
UserName	`varchar` Displays the Vocera Voice Server user internal id.	`u-jsmith`
PingState	`varchar` Displays the ping/UI state of the device (for example: Standby).	`Standby`
owningGroupName	`varchar` Displays the name of the device's owning group.	`Engineering`
owningGroupDepartments	`varchar` A comma-separated list of the owning group departments.	`g-engineering0,g-office`
userDisplayName	`varchar` Specifies the user display name.	`Smith, John`
userDepartments	`varchar` Specifies the user departments.	`g-operations,g-tech_support`
userSite	`varchar` Displays the user's home site.	`MySiteName`
TrackingTime	`varchar` Displays the device tracking time.	`2017-11-21`
Label	`varchar` Displays the label.	`MyCompanyName John Smith`
Status	`varchar` Displays the device status (for example: Active, Unregistered, RMA'ed).	`Active`
OwningGroupSite	`varchar` Displays the site of the group that owns the device, if any.	`MyGroupSite`
OwningGroupID	`varchar` Displays the id of the group that owns the device.	`g-mygroupname`