The WP Activity Log plugin stores all the user configurable and non user configurable settings in the wp_wsal_options table. The below is a list of all the settings, possible configured values and the scope of each setting.
For more information on how the activity logs are saved in the database refer to the WP Security audit Log plugin database documentation.
| Option Name | Value | Purpose |
|---|---|---|
| wsal-version | Current plugin version | Needed by the upgrade procedures of the plugin. |
| wsal-disabled-alerts | list of event ids separated by comma | The list of disabled event IDs. |
| wsal-log-404 | on / off | Capture 404 requests from users to file. |
| wsal-purge-404-log | on / off | Purge 404 requests from users from file. |
| wsal-log-404-referrer | on / off | Log referrers of 404 request from users. |
| wsal-log-404-limit | Number | Number of 404 requests by users to keep a log of. |
| wsal-log-visitor-404 | on / off | Capture 404 requests of visitors to a file. |
| wsal-purge-visitor-404-log | on / off | Purge 404 requests from visitors from file. |
| wsal-log-visitor-404-referrer | on / off | Log referrers of 404 request from visitors. |
| wsal-log-visitor-404-limit | Number | Number of 404 requests from visitors to keep a log of. |
| wsal-log-failed-login-limit | Number | Number of failed users' login requests to keep a log of. |
| wsal-log-visitor-failed-login-limit | Number | Number of 404 requests by visitors to keep a log of. |
| wsal-site_content | stdClass object | List of current and newly added plugins and themes in between file integrity scans. |
| wsal-wsal-setup-modal-dismissed | yes / empty | Ask first time install users if they want to use the wizard to configure the plugin. |
| wsal-details-level | basic / geek / custom | The activity log detail level (preset list of enabled / disabled events). |
| wsal-pruning-date-e | 1 / empty | Indicates if activity log retention is enabled or not. |
| wsal-pruning-date | Time in months or years | The period configured for the activity log retention. |
| wsal-pruning-unit | Months or years | Log retention date unit. |
| wsal-plugin-editors | List of usernames | List of usernames allowed to edit plugin settings and view the activity log. |
| wsal-excluded-users | List of usernames | List of users excluded from the activity logs. |
| wsal-excluded-roles | List of user roles | List of user roles excluded from the activity logs. |
| wsal-excluded-ip | List of IP addresses | List of IP addresses excluded from the activity logs. |
| wsal-wsal-setup-complete | yes / empty | Indicates whether the user has completed the initial setup wizard or not. |
| wsal-dismissed-privacy-notice | 1,wsal_privacy / empty | Indicates whether the user dismissed the first time activity log indicator popup. |
| wsal-connection-* | stdClass object | User created connections and their connection details. |
| wsal-mirror-* | stdClass object | The connection details for the mirroring connection. |
| wsal-adapter-use-buffer | 1 / empty | Use buffer to store events before sending them to adaptor. |
| wsal-adapter-connection | Connection Name | The name of the connection the plugin is using for the external database connection. |
| wsal-adapter-type | mysql | Stores the database type used for storing the activity log. |
| wsal-adapter-user | Username | The username for the external database connection. |
| wsal-adapter-password | Encrypted password | The encrypted password used for the external database connection. |
| wsal-adapter-name | Database name | The database name of the external activity log database. |
| wsal-adapter-hostname | localhost / IP address | The server name of where the external database is hosted. |
| wsal-adapter-base-prefix | Base Prefix | The tables prefix for for the activity log external database. |
| wsal-adapter-url-base-prefix | 1 / empty | Use the website URL as database table prefix in the external database. |
| wsal-adapter-ssl | 1 / empty | Use SSL for the external database connection. |
| wsal-adapter-client-certificate | 1 / empty | Use Client certificate for the external activity log database connection. |
| wsal-adapter-ssl-ca | Path to CA SSL Certificate | The location of the CA SSL certificate and the certificate's name for the external database connection. |
| wsal-adapter-ssl-cert | Path to Server SSL Certificate | The location of the Server SSL certificate and the certificate's name for the external database connection. |
| wsal-adapter-ssl-key | Path to Client Certificate | The location of the Client certificate and the certificate's name for the external database connection. |
| wsal-archiving-e | 1 / empty | Indicates whether archiving of activity log is configured and enabled or not. |
| wsal-archiving-stop | 1 / empty | indicates whether archiving of the activity log is stopped . |
| wsal-archiving-run-every | fifteenminutes, hourly, sixhours, twicedaily, daily | The frequency of the archiving job. |
| wsal-archiving-date | Number | The number of months or years for configured archiving. |
| wsal-archiving-date-type | months / years | The date unit used in the archiving setting. |
| wsal-archive-connection | Connection name | The name of the connection for the activity log archiving. |
| wsal-archive-type | mysql | The database server type of the archive database. |
| wsal-archive-user | Username | The username to connect to the archiving database. |
| wsal-archive-password | Encrypted Archive Storage Password | The password to connect to the archiving database. |
| wsal-archive-name | Archive Storage DB Name | The name of the archiving database. |
| wsal-archive-hostname | localhost or IP address | The server name of the archiving database. |
| wsal-archive-base-prefix | Base prefix | The tables prefix for the archiving database. |
| wsal-archive-url-base-prefix | 1 / empty | Use the website URL as database table prefix in the archiving database. |
| wsal-archive-ssl | 1 / empty | Use SSL for the archiving database connection. |
| wsal-archive-client-certificate | 1 / empty | Use client certificate for the archiving database connection. |
| wsal-archive-ssl-ca | Path to CA SSL Certificate | The location of the CA SSL certificate and the certificate's name for the archiving database connection. |
| wsal-archive-ssl-cert | Path to Server SSL Certificate | The location of the Server SSL certificate and the certificate's name for the archiving database connection. |
| wsal-archive-ssl-key | Path to Client Certificate | The location of the Client certificate and the certificate's name for the archiving database connection. |
| wsal-wc-all-stock-changes | on / off | Keep track of live stock changes in WooCommerce products. |
| wsal-disable-visitor-events | yes / no | Visitors sensor for public events. |
| wsal-scan-file-changes | enable / disable | File integrity scans. |
| wsal-scan-frequency | Daily / Weekly / Monthly | File integrity scan frequency. |
| wsal-scan-hour | Hour of the day | The hour of the day when the file integrity scan should run. |
| wsal-scan-day | Day of the week | The day of the week when the file integrity scan should run. |
| wsal-scan-date | Date of the month | The day of the month when the file integrity scan should run. |
| wsal-scan-file-size-limit | Number | The maximum file size limit for the file integrity scanner to scan. |
| wsal-scan-directories | Array of directories | List of directories the file integrity scanner should scan. |
| wsal-scan-in-progress | 1 / empty | Indicates whether a file integrity scan is in progress. |
| wsal-is_initial_scan_* | yes / no | Indicates whether the file integrity scan is the initial one for a directory. |
| wsal-local_files_* | Array of files | The list of files scanned during the last file integrity scan of a directory. |
| wsal-stop-scan | 1 / empty | Stop manual file integrity scans if set to 1 otherwise don't. |
| wsal-items-per-page | Number | Number of events to display in the activity log viewer. |
| wsal-user-management-allow-multi-sessions | 0 / 1 / allow-limited | Block multiple sessions. |
| wsal-user-management-allowed-sessions-number | Number | The maximum number of simultaneous sessions per user. |
| wsal-user-management-blocked-sessions-override | override_block / without_warning / with_warning | Blocked users sessions override options. |
| wsal-user-management-sessions-override-password | Encrypted password | The user session override password. |
| wsal-user-management-sessions-error-message | Text | The message shown to users when their session is blocked. |
| wsal-hide-plugin | 0 / 1 | Hide the plugin name in the plugin's page. |
| wsal-restrict-admins | 0 / 1 | Restrict plugin access to other administrators. |
| wsal-mwp-child-stealth-mode | yes / no | MainWP child site stealth mode (activated automatically when installed on a site with MainWP Child Site plugin) |
| wsal-use-email | default_email / custom_email | Use the default admin email or a custom user specified email. |
| wsal-from-email | Email Address | The from email address the plugin uses in the email notifications. |
| wsal-display-name | Display Name | The display name the plugin uses in the email notifications. |
| wsal-disable-widgets | 0 / 1 | Show the plugin widget in the dashboard. |
| wsal-disable-admin-bar-notif | 1 / empty | Disable the admin bar live notification. |
| wsal-plugin-viewers | List of usernames | Users who can view the activity log. |
| wsal-restrict-plugin-settings | only_me / only_admins / only_selected_users | Who has access to the plugin settings and activity log. |
| wsal-login_page_notification | true / false | Display the login page notification. |
| wsal-login_page_notification_text | Text | The login page notification message. |
| wsal-use-proxy-ip | 0 / 1 | Use the IP address of the reverse proxy in the activity log. |
| wsal-filter-internal-ip | 1 / empty | Filter internal IP adddresses when supporting reverse proxies / WAFs. |
| wsal-events-nav-type | infinite-scroll / pagination | Event viewer navigation type setting. Default value is inifinite-scroll. |