Audit Logs Overview
The audit log is the report of all the activities done in your ToolJet account. It will capture and display events automatically by recording who performed an activity, what when, and where the activity was performed, along with other information such as IP address.
Date Range
Retrieve the log of events that occurred within the specified date and time range using the range picker. By default, the system loads 24-hour logs for the initial view. The maximum duration that can be specified for the "from" and "to" dates is 30 days.
Pagination at the bottom allows navigation through the pages, with each page displaying a maximum of 7 logs.
Audit Log Retention Period
By default, audit logs are retained for 90 days. However, admins can customize this retention period by setting the following environment variable:
AUDIT_LOGS_RETENTION_PERIOD;
To retain audit logs indefinitely, set the variable to 0.
Filter Audit Logs
You can apply filters to the audited events based on the following criteria.
Select Users
Choose a specific user from the dropdown list to view all their activities.
Select Apps
The dropdown will display all the apps associated with your account. Select an app to filter the logs related to that particular app.
Select Resources
Resources | Description |
|---|---|
| User | Filter all the User events like USER_LOGIN, USER_SIGNUP, USER_INVITE, AND USER_INVITE_REDEEM. |
| App | Filter all the App events like APP_CREATE, APP_UPDATE,APP_DELETE,APP_IMPORT,APP_EXPORT,APP_CLONE. |
| Data Query | Filters the events associated with Data Query like DATA_QUERY_RUN. |
| Group Permission | All the events associated with Group Permissions will be filtered. Group Permissions include GROUP_CREATE, GROUP_UPDATE, GROUP_DELETE. |
| App Group Permission | Within each group, you can set apps for read or edit privileges. These events get recorded as App Group Permissions. |
Select Actions
User
Actions | Description |
|---|---|
| USER_LOGIN | This event is recorded everytime a user logins. |
| USER_SIGNUP | This event is recorded everytime a new signup is made. |
| USER_INVITE | You can invite users to your account from Manage Users section and an event is audited everytime an invite is sent. |
| USER_INVITE_REDEEM | This event is recorded whenever an invite is redeemed. |
| USER_LOGOUT | This event is recorded whenever a user logs out. |
| USER_ARCHIVE | This event is recorded whenever a user is archived. |
| USER_UNARCHIVE | This event is recorded whenever a user is unarchived. |
| USER_PROFILE_UPDATE | This event is recorded whenever a user's name or avatar is updated. |
| USER_PASSWORD_FORGOT | This event is recorded whenever a user requests forgot password link from the login screen. |
| USER_PASSWORD_RESET | This event is recorded whenever a super admin resets a user password at the instance level. |
| USER_PASSWORD_UPDATE | This event is recorded whenever a user update the password from profile settings. |
| USER_DETAILS_UPDATE | This event is recorded whenever a super admin updates the user details. |
User Groups and Permissions
Actions | Description |
|---|---|
| SET_AS_SUPERADMIN | This event is recorded whenever a user is promoted to super admin. |
| GROUP_PERMISSION_CREATE | This event is recorded whenever a group is created. |
| GROUP_PERMISSION_UPDATE | This event is recorded whenever an app or user is added to or removed from a group, or the permissions for a group are updated. |
| GROUP_PERMISSION_DELETE | This event is recorded whenever a user group is deleted from an account. |
| GROUP_PERMISSION_DUPLICATE | This event is recorded whenever a group and permission is duplicated. |
| USER_ADD_TO_GROUP | This event is recorded whenever a user is added to a group. |
| USER_REMOVE_FROM_GROUP | This event is recorded whenever a user is removed from a group. |
| GRANULAR_PERMISSION_APP_CREATE | This event is recorded whenever an app level granular permission is created. |
| GRANULAR_PERMISSION_APP_UPDATE | This event is recorded whenever an app level granular permission is updated. |
| GRANULAR_PERMISSION_APP_DELETE | This event is recorded whenever an app level granular permission is deleted. |
| GRANULAR_PERMISSION_DATA_SOURCE_CREATE | This event is recorded whenever a data source level permission is created. |
| GRANULAR_PERMISSION_DATA_SOURCE_UPDATE | This event is recorded whenever a data source level permission is updated. |
| GRANULAR_PERMISSION_DATA_SOURCE_DELETE | This event is recorded whenever a data source level permission is deleted. |
Workspace
Actions | Description |
|---|---|
| WORKSPACE_CREATE | This event is recorded whenever a new workspace is created. |
| WORKSPACE_UPDATE | This event is recorded whenever a workspace name or slug is updated. |
| WORKSPACE_ARCHIVE | This event is recorded whenever a workspace is archived. |
| WORKSPACE_UNARCHIVE | This event is recorded whenever a workspace is unarchived. |
| WORKSPACE_LOGIN_SETTINGS_UPDATE | This event is recorded whenever workspace login settings is updated. |
App
Actions | Description |
|---|---|
| APP_CREATE | This event is recorded when a user creates a new app. |
| APP_UPDATE | This event is recorded whenever actions like renaming the app, making the app public, editing shareable link, or deploying the app are made. |
| APP_PROMOTE | This event is recorded whenever an application's environment is promoted. |
| APP_RELEASE | This event is recorded whenever an application is released. |
| APP_SHARE | This event is recorded whenever an application is shared. |
| APP_PUBLIC_UPDATE | This event is recorded whenever an application is made public. |
| APP_DELETE | This event is recorded whenever a user deletes an app from the dashboard. |
| APP_IMPORT | This event is recorded whenever a user imports an app. |
| APP_EXPORT | This event is recorded whenever an app is exported. |
| APP_CLONE | This event is recorded whenever a clone of the existing app is created. |
| APP_VERSION_CREATE | This event is recorded whenever a new version of an application is created. |
| APP_VERSION_UPDATE | This event is recorded whenever a version of an application is updated. |
| APP_VERSION_DELETE | This event is recorded whenever a version of an application is deleted. |
Data Source
Actions | Description |
|---|---|
| DATA_SOURCE_CREATE | This event is recorded whenever a new data source is created. |
| DATA_SOURCE_UPDATE | This event is recorded whenever a data source is updated. |
| DATA_SOURCE_DELETE | This event is recorded whenever a data source is deleted. |
| DATA_QUERY_RUN | This event is logged whenever a query run either from the query editor or from the launched app. |
Understanding Log Information
Property | Description |
|---|---|
| action_type | This indicates the type of action that was logged in the event. Refer to this for more information on actions. |
| created_at | Shows the date and time when the event was logged. |
| id | Each logged event is assigned a unique event ID. |
| ip_address | Displays the IP address from which the event was logged. |
| metadata | The metadata includes two sub-properties: tooljet_version and user_agent. tooljet_version shows the version of ToolJet used for the event, while user_agent contains information about the device and browser used. |
| organization_id | Every organization in ToolJet has a unique ID associated with it, which is recorded when an event occurs. |
| resource_id | Different resources have their respective IDs associated with them. These IDs are assigned when the resources are created. |
| resource_name | Shows the name of the resources that were involved in the logged event. For example, if an app was created or deleted, it will display the name of that app. |
| resource_type | Indicates the type of the resources involved in the logged event. |
| user_id | Each user account in ToolJet has a unique ID associated with it, which is recorded when an event occurs. |
Log File
The file will contain all the data from audit logs. The log file can be created by specifying the path in the environment variables. The log file is rotated on a daily basis and is updated dynamically every time a new audit log is generated.
Learn more about setting up the log file generation here.
Log Rotation
The log file is configured to rotate on a daily basis. This means that a new log file will be created every day, ensuring efficient management and organization of audit data.
Log Redaction
ToolJet implements log redaction to protect sensitive information. By default, the following headers are masked in the logs:
- authorization
- cookie
- set-cookie
- x-api-key
- proxy-authorization
- www-authenticate
- authentication-info
- x-forwarded-for
Additionally, you can specify custom fields to be masked using the LOGGER_REDACT environment variable.
Variable | Description |
|---|---|
| LOGGER_REDACT | Comma-separated list of additional fields to be masked in logs (e.g., req.headers["x-session-id"],req.headers["x-device-fingerprint"]) |
For example:
LOGGER_REDACT=res.headers["x-rate-limit-remaining"],res.headers["x-request-id"]
Log File Path
The path for the log file is defined using the LOG_FILE_PATH variable in the environment. It's important to understand that this path is relative to the home directory of the machine. For instance, if LOG_FILE_PATH is set to hsbc/dashboard/log, the resulting log file path will be structured as follows:
homepath/hsbc/dashboard/log/tooljet_log/{process_id}-{date}/audit.log
Here, {process_id} is a placeholder for the unique process identifier, and {date} represents the current date. This structured path ensures that audit logs are organized by both process and date, facilitating easy traceability and analysis.
Variable | Description |
|---|---|
| LOG_FILE_PATH | the path where the log file will be created ( eg: tooljet/log/tooljet-audit.log) |
Example Log file data
{
level: 'info',
message: 'PERFORM APP_CREATE OF awdasdawdwd APP',
timestamp: '2023-11-02 17:12:40',
auditLog: {
userId: '0ad48e21-e7a2-4597-9568-c4535aedf687',
organizationId: 'cf8e132f-a68a-4c81-a0d4-3617b79e7b17',
resourceId: 'eac02f79-b8e2-495a-bffe-82633416c829',
resourceType: 'APP',
actionType: 'APP_CREATE',
resourceName: 'awdasdawdwd',
ipAddress: '::1',
metadata: {
userAgent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36',
tooljetVersion: '2.22.2-ee2.8.3'
}
},
label: 'APP'
}