Audit Logs

Audit logs enable 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. Using audit logs, admins can ensure adherence to their organization’s security standards and compliance policies.

Note: Audit logs are included with Platform and above plans with six months data retention and are 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 one, three, and seven years.

Audit logs are rolling logs based on the selected data retention period. A total of 90 days of activity is available. Audit logs are available for the following activity types:

Activities Types
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

This topic describes how to:

Enable data change logs

Admins can view activity details for an app. By default, data change tracking is disabled. Admins can enable or disable audit logs for up to 20 apps per realm from the Apps page of the Admin Console. To enable and disable apps to record data changes in audit logs, select the check box on the left of the app, and then click the option at the top of the page to enable or disable.

Additionally, 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.

View details of data changes

When admins enable audits for data change logs at both the app and field level, they can view data changes in audit logs and click each change for more detail.

If existing data was updated, the old and new values display next to each other.

Query and filter audit logs

Admins can customize how to query their audit logs by using the following filters:

  • Start and end dates - Enter a date range from one to seven days, inclusive.
  • App name
  • User email
  • Log ID - Search all audit logs within the retention period purchased.

Note: The app name filter does not currently support querying for deleted apps.

To query audit logs using a filter:

  1. Click Audit Logs on the left-hand navigation bar of the Admin Console, or on the left-hand navigation bar of the Manage Billing Account page.
  2. Select a filter at the top of the page. Based on the filter chosen, enter the appropriate information. You can use either the Log ID as a single filter, or any combination of the dates, app name, and user email filters.
    Note: If you do not specify an app name, user email, or log ID filter, all activity within the specified date range displays.

  3. Click Display logs to apply the chosen filter(s). You can repeat the steps to change and/or combine filters to alter your results.

Audit logs display the following information:

Item Description
Log ID  Auto-generated identifier of the audit log.
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, create app, report access, or table search.
Browser 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 that you can click to see additional details.

Download audit logs

Admins can download audit log information in seven-day increments. A total of 90 days of activity is available. Downloaded logs contain all the information available in the user interface plus IDs. To download an audit log:

  1. Click Audit Logs on the left-hand navigation bar of the Admin Console, or on the left-hand navigation bar of the Manage Billing Account page.
  2. Select filters to customize how to query the audit logs.
  3. Click Display logs to view the log activity.
  4. Click Download to generate a .csv file of the audit logs.


Go back      |       

© 1999-2019  QuickBase, Inc.  All rights reserved.  Legal Notices.