Database View Tables

These database views are useful for the report writer.

v_dimgroups
This view gets group data from Vocera Voice Server groups and VMP distribution lists.
v_dimgroupsdepartments
This view maps Vocera Voice Server internal group ids to VMP distribution list internal ids and department mappings.
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.
v_dimsites
This view maps from internal Vocera Voice Server site ids and names to VMP internal site ids.
v_dimusers
The single distinct view of users from VMP and the Vocera Voice Server.
v_dimusersgroups
The user groups database view.
v_fctcalls
This view gets information on calls and broadcasts with their required fields.
v_groupconversations
This view lists the messages sent to any distribution list using the Vocera Collaboration Suite application.
v_vmpusers
The VMP users database view.