v_dimgroupsdepartments

This view maps Vocera Voice Server internal group ids to VMP distribution list internal ids and department mappings.

Table 1. v_dimgroupsdepartments
Column	Description
groupId	`bigint` The unique group id.
vmpId	`bigint` The VMP id.
name	`varchar` The group name.
type	`varchar` The group type.
siteName	`varchar` The site name for the group.
siteId	`varchar` The id of the group's site.
isDeleted	`tinyint` Whether the group has been deleted (1=yes, 2=no).
departments	`varchar` The comma-separated list of internal Vocera Voice Server department ids.