These summary tables are automatically produced every day for use in reports and dashboards.
summarycalls
The Summary Calls table aggregates data for Vocera Voice Server sites and units (Vocera Voice Server departments) each day with the accepted, declined, and total number of calls.
summarydeviceactivity
This summary table lists the latest device activity on a per-day basis.
summaryengagedata
This summary table aggregates the accepted, declined and total data counts, grouped by site, unit, severity, and interrupt source type(interrupt type).
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.
summaryspeech
This summary table aggregates daily data from the fctrecresults table: recognized, rejected, and other speech items, and speech, non-speech, and total counts, grouped by user's Vocera Voice Server Site and Department.
summaryspeechlocation
This summary table aggregates daily data from the fctrecresults table: recognized, rejected, and other speech items, and speech, non-speech, and total counts, grouped by location site and MAC address.
summaryspeechowninggroup
This summary table aggregates daily data from the fctrecresults table: recognized, rejected, and other speech items, and speech, non-speech, and total counts, grouped by device.
summaryspeechuser
This summary table aggregates daily data from the fctrecresults table: recognized, rejected, and other speech items, and speech, non-speech, and total counts, grouped by user.
summaryvmialerts
This summary table aggregates daily data from the vmialerts table: total VMI alert counts grouped by severity, user Vocera Voice Server site, and user department.
