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.

Table 1. summaryvmialerts table
Column Description Example
Txdate

date

The date of the aggregated data.

2017-10-08
Site

varchar

In a multi-site installation, the column specifies the Vocera site with which the recipient is associated.

MySiteName
Unit

varchar

The unit with which the recipient user is associated. This is a comma-separated list of internal group ids.

g-engineering0
clientID

varchar

The VMI client ID.

VMILoad
Severity

varchar

The severity of the alerts (normal, high, urgent).

normal
TotalVMIAlerts

bigint

The total number of VMI alerts.

44