The Database Audit Log retains information about changes made in a Database, Form or Folder as well as the user(s) who applied these changes. This article describes the steps for viewing and filtering Database Audit Logs.
A Database Audit Log provides a list of past events within a Database. You might want to have access to these events in order to review which users updated a Form, a Record or a Lock for example.
In the Database Audit Log, you can review the following events:
- Adding, updating or deleting Records
- Updating Form schemas
- Adding, updating, or deleting Folders, Locks, Roles
- Deleting or moving Forms or updating Form's visibility
- Adding or deleting users, or changing their permissions
In some cases you can revert actions, such as:
The Database Audit Log can be viewed by Database owners and users with permission to perform the “Audit user actions” operation .
Viewing the Audit log
To open the Audit Log, follow these steps:
- Navigate to the Database List page.
- Select the Database for which you want to view the Audit Log.
- Click "Database settings."
- Click "Audit log" on the left side panel.
- Review the Database Audit Log.
You may see the following labels:
- “Reverted” means that the Record was deleted and then later recovered.
- “Updated database” signifies a change to a Folder, Form, Lock or Role.
- “Added” for new information entered.
- “Deleted” for removed data.
- Select a log entry to open the Audit Log side panel.
Audit Log Review Actions
When you select an audit log entry for review, you have the following action options:
- Emailing the user who made the change
- Opening the Form that contains the selected Record
- View the selected Record itself
- Review the Record history in the audit log sidebar, which contains all the changes to field values.
- Recover deleted records. For more information, see Recovering a deleted Record, Form, Folder or Field.
Filtering
You can filter the Audit Log results in the following ways:
- Select a Date and show events that happened before that date by clicking on "Events before ..." and selecting a date.
- Filter by event type clicking "Filter by event type" and selecting the filter(s) you want to use by checking the boxes.
- Filter by Form or Folder by clicking "Filter by form or folder" and selecting the Folder or Form for which you want to view the events.
You can only view the top level Forms in this list, that is Forms that don't belong in any Folder. If the Form belongs in a Folder, select the Folder instead.
- To remove a filter click on the 'x' next to the filter name.
- To remove all filters click on "Clear all filters".