Setting Up Vocera Analytics / Configuring VMI Data
Parent topic: Configuring VMI Data

Configuring VMI Responses

This section describes configuring VMI responses to be categorized as Accepted.

To configure VMI responses to be categorized as Accepted, perform the following:
  1. Connect to the Vocera Analytics (vocera_analytics) database.
  2. Add the response to dimvmiresponse table.

    For example, if you want to add accepted-yes as the accepted response, use the command:

    INSERT INTO `dimvmiresponse`(`AcceptResponses`,`RejectResponse`)VALUES('accepted-yes',NULL);

    Similarly, you can update or delete entries from this table.

    After you execute this command, the new data arriving into the Vocera Analytics system will show as accepted for the response accepted-yes.

To modify old data in Vocera Analytics database, perform the following:
  1. Connect to the Vocera Analytics (vocera_analytics) database.
  2. Run the query: truncate vmialerts;

    This query removes the old data from the database.

  3. Run the query: call CreateVMIAlertsNormalization()

    This query aggregates the VMI data.

Parent topic: Configuring VMI Data

This guide last modified: 2021-04-23 06:45.  .   http://www.vocera.com