Audit logs allow admins to gain greater visibility into how users access their apps and the types of changes that are made to data and structure within those apps to ensure they comply with their organization’s security standards and corporate compliance policies.
Note: Audit logs are included with Platform and above plans with 6 months data retention and available as an add-on for Premier plans. Data retention is the continued storage of an organization's data for compliance or business reasons.
Retention packages are available for 1, 3, and 7 years. Audit logs are rolling logs based on the chosen data retention period.
Currently, audit logs are available for:
- User events
- User creation
- User token creation, deletion, activation, or deactivation
- All successful log-ins and log-outs
- Data access and changes
- App and table searches
- App and table home page access
- Record access, creation, modification, or deletion
- Report access
- Schema changes
- App creation and deletion
- Table creation and deletion
- Relationship creation and deletion
- Field creation and deletion
Viewing audit logs
Admins can view audit log information in 7-day increments. A total of 90 days of activity is available.
Audit logs display:
|First Name||User’s first name.|
|Last Name||User’s last name.|
|Email Address||User’s email address.|
|Action||What action was taken, such as log in, report access, or table search.|
|Time||Exact time the action was taken, including date, and time with hour, minutes and seconds. Time zone is the browser time zone.|
|IP||The IP address the action was taken from.|
|User Agent||The browser and OS the action was taken from.|
|Application||UI for user interface or API for an API call.|
|Description||A brief description of the action.|
Detailed Data Change Logs
Enabling detailed logging
Admins can view details of add, edit, and delete data changes.
Tracking of data changes will be off by default. Realm admins can enable audit logs for up to 20 apps per realm from the Apps page of the Admin Console. To enable, select the checkmark under Data change logs.
Note: Enabling data change logs is not currently available on the Apps (Beta) page.
Then, app admins can select up to 50 fields per table to track for data changes by selecting Track this field for audit purposes in field properties. Formula and summary fields are not supported.
Note: There is a data size limit of 0.25 megabytes per record, which equates to 250,000 characters or about 40,000 words. If your app has lengthy field values and you are tracking many fields, the amount of data displayed in each field may be truncated.
Viewing details of data changes
When audits for data change logs are enabled at both the app and field level, admins can view data changes in their audit logs and click each change for more detail.
If existing data was updated, the old and new values display side by side.
Downloading audit logs:
Admins can download audit log information in 7-day increments. A total of 90 days of activity is available. Downloaded logs contain all the information available in the user interface plus IDs, such as event ID, user ID, and realm ID. To download
Click Audit Logs on the left-hand nav bar of the Admin Console or the left-hand nav bar of the Manage Billing Account page.
- Click Download, enter a date range, and click Download for a .csv file of audit logs.
© 1999-2019 QuickBase, Inc. All rights reserved. Legal Notices.