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 Example
groupId

bigint

The unique group id.

4948
vmpId

bigint

The VMP id.

7
name

varchar

The group name.

Support Test
type

varchar

The group type.

R
siteName

varchar

The site name for the group.

MySiteName
siteId

varchar

The id of the group's site.

s-mysitename
isDeleted

tinyint

Whether the group has been deleted (1=yes, 2=no).

0
departments

varchar

The comma-separated list of internal Vocera Voice Server department ids.

g-2100,g-21000