vmialerts

Stores information for VMI alerts.

Table 1. vmialerts table
Column Description Example
TxDate

date

Stores the date of an event, accurate to the day.

2017-10-08
Txmillis

bigint

Gives each row in the table a unique identifier. The value represents the number of milliseconds since January 1, 1970 (a date specified for internal use by the report system). Because of the uniqueness constraint, it may not reflect the exact actual date.

1507514375333
messageInitiatedAt

datetime

Stores the date and time of the message initiation event, accurate to the second.

2017-10-08 21:40:12
txdatetime

datetime

Stores the date and time of the event, accurate to the second.

2017-10-08 18:59:35
MessageId

bigint

The VMI message id.

1
ClientId

varchar

The VMI client id.

VMILoad
MessageText

varchar

The VMI message text.

Test message for TestUser1.
priority

varchar

Specifies the VMI message priority (Normal, High, Urgent).

Normal
priorityId

int

Specifies the VMI message priority id (0 = normal, 1 = high, 2 = urgent).

0
RecipientType

varchar

Specifies which type of entity received the message (for example: User, Group).

User
recipientSite

varchar

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

VCSLoadSite
recipientId

varchar

For users, this is the user id specified in the Vocera Voice Server Administration Console. For groups, this is the actual group name.

JohnSmith
recipientU_id

varchar

Specifies the internal Vocera Voice Server id of the message recipient.

u-jsmith
recipientDisplayName

varchar

Specifies the display name (LastName, FirstName) of the message recipient.

Smith, John
ActionType

varchar

Specifies the action type (for example: Accepted, Delivered, Rejected)

Accepted
Actiondetail

text

Specifies the details of the action (for example, the reason why the alert was rejected).

User is not on network
Response

longtext

The alert response (for example: CallBack, Ok, Busy, Cancel).

CallBack
receiveruserdepartments

varchar

Specifies the user departments.

g-tech_support
receivergroupDepartments

varchar

Specifies the group departments.

g-testgroup
DestinationType

varchar

Specifies the destination type (for example: User, Group).

User
DestinationName

varchar

Specifies the destination name.

Jane Doe
destinationU_id

varchar

Specifies the destination name userid.

u-jdoe
DestinationSite

varchar

In a multi-site installation, the column specifies the Vocera site with which the destination is associated. In a single-site installation, this value is null.

MySiteName