Working with Database Settings

The Audit Log's Database settings tab allows you to view the current database, download the current database (in zip or CSV format), and upload or delete a database snapshot.

Audit uses a number of partitions (14 by default) to capture audit events over time. The number of partitions has a lower bound of two but no upper bound. A partition is a Postgres table containing audit events within a time bound. The partition's time bound is configurable (24 hours by default) with the minimum number being one hour.

When the system is writing to the last partition, the oldest partition is dropped and a new one partition is created. This partition rotation is not a persistent archive, but provides access to history without the database growing unbounded. Please use the Backups functionality to manage audit event history through regular database backups in the Vocera Platform Web Console.

This Database section provides the ability to download the current database in a .zip or .cvs file. The download file may contain all entries across all partitions in the audit log database. Any filter criteria used in the audit log viewer when the snapshot is taken are applied to the downloaded entries. For example, if the audit log viewer is filtered to only show a subset of the audit entries, then the downloaded database snapshot will contain only the entries shown in the audit log viewer.

Warning: The Database will NOT download and restore if the user is utilizing a Mac with the OS X operating system. To work around this issue, disable Safari's automatic archive unzip function: select Preferences > General, and uncheck the "Open safe files after downloading" option.

Navigate to the Audit Log configuration dialog as described in Accessing the Audit Log Configuration Settings.
In the Database section, select Zip or CSV to take a snapshot of the current database.
Once a snapshot is downloaded to storage, select Choose File to navigate to the database snapshot and then click Upload Audit Event Snapshot to upload the snapshot to the system.
Select the uploaded database snapshot in the Selected Audit database field, then click Upload Audit Event Snapshot to load it to the Audit Log.
Verify the correct snapshot version uploaded by checking the Database field in the footer of the Audit Log viewer. Any filter criteria used in the audit log viewer when the snapshot was taken will display in the uploaded entries.
To delete a database snapshot, select a database snapshot in the Selected Audit database field, then click Delete Selected Database.
The Delete option is provided for snapshots, and is not available when Current Database is selected.
Select Close to exit the configuration dialog.
The Audit Log section displays.