Skip to main content

Audit logs

Audit logs overview

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

Note: Audit logs are included on all plans. Data retention (how long audit data is stored and accessible for compliance or business purposes) varies by plan. Visit the Quickbase Plans and Pricing page for more details.

What kind of things are logged?

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

  • User invited to an app

  • User granted access to an app

  • Update a user's role

  • Remove a user from an app
Group events

  • User added to a group

  • User removed from a group
Role events

  • Create a role

  • Delete a role

  • Update the name of a role

  • Allow/disallow a user to add records in a table

  • Allow/disallow a user to save public views in a table

  • Allow/disallow a user to delete records in a table

  • Allow/disallow a user to edit field properties in a table

  • Grant permission to manage users and share the app

  • Grant permission to edit app structure and permissions

  • Grant permissions to disable access to app for users in the role
Login failures

  • Login failure due to invalid credentials. For example:

    • Username does not exist

    • Password is incorrect

    • User has been deactivated

  • Login failure due to an invalid ticket. For example:

    • Ticket cannot be authenticated

    • Ticket is expired

    • Ticket is not authorized for the specific table or app someone is trying to access

  • Login failure due to an invalid user token
Data access and changes

  • App and table searches

  • App and table home page access

  • Rich text page access

  • Code page access

  • Record access, creation, modification, or deletion

  • Report access, including through a URL redirect

  • Dashboard creation, updates, access, and deletion

  • Form activity through a URL redirect

  • Downloading all forms and users in app when going offline in mobile

  • Calls to API_DoQueryCount, a call which counts the number of records in a table that match a set of criteria

  • Calls to API_DoQuery, a call which queries records in a table that match a set of criteria

  • User accessed data in a table in the app

  • User accessed data in a table in the app via an API

  • Searches at the app level, including the number of tables searched

  • Embedded reports access
Schema changes

  • App creation and deletion

  • Table creation and deletion

  • Relationship creation and deletion

  • Field creation and deletion

  • Enabling and disabling offline mode
Solution events
  • Solution creation and deletion
  • Apps: add/delete from a solution
  • Pipelines: add/delete from a solution
  • Contributors: add/delete from a solution
  • Version creation and deletion
  • Version rollback 

Using Audit Logs

Tracking data changes in a specific field

Viewing data changes in the Audit Logs

Querying and filtering Audit Logs

Downloading Audit Logs

Related articles

Top