v_dimgroupsusers

Single view of the Vocera Voice Server group ID and user id, and of the VMP distribution list id and internal user id.

Table 1. v_dimgroupsusers table
Column	Description	Example
userId	`varchar` For Vocera Voice Server users, this is the Vocera Voice Server internal id. For standalone VMP users, this is the VMP internal id. For Vocera Secure Texting users, this id is negative.	`u-myusername`
groupId	`varchar` For Vocera Voice Server groups, this is the internal Vocera Voice Server group id. For VMP distribution lists, this is the internal VMP distribution list id.	`g-mygroupname`
type	`bigint` The group type (Group or DistList).	`DistList`