summarymessages

This summary table aggregates the text message data of vmpMessages table: conversation count (TotalEvents), delivered count (TotalDeliveries), total messages grouped by Vocera Voice Server Site (site) and Department (unit) per day.

Table 1. summarymessages table

Column	Description	Example
TxDate	date DEFAULT NULL The date of the aggregated data.	2017-12-09
Site	varchar The site for the message receiver user.	MySiteName
Unit	varchar The receiver user's department.	g-engineering0
severity	varchar The message severity (normal, high, urgent).	normal
TotalEvents	bigint The total number of conversations.	1
TotalDeliveries	bigint The total number of deliveries.	12
TotalMessages	bigint The total number of messages. This is usually the same as the total number of deliveries.	12