SleekView for WP Activity Log: occurrences & meta as tables
WP Activity Log writes every event to wp_wsal_occurrences and pivots context fields into wp_wsal_metadata. SleekView joins both tables into a single audit grid you can pivot, filter, and annotate in WP Admin.
♾️ Lifetime License available
Audit logs that bend to your questions
WP Activity Log keeps a tight schema: wp_wsal_occurrences stores the event itself with severity, alert code, user ID, IP, and a created-on timestamp, while wp_wsal_metadata holds the variable context as a key/value pivot. The plugin's built-in viewer reads both, but the UI funnels you down a fixed path: pick a date, pick a user, optionally pick an alert. The richer story sits in metadata that the default columns never expose.
SleekView treats those two tables as a single source. It reads wp_wsal_occurrences and joins the metadata rows back onto the occurrence so each grid row carries the alert code, the user, the role, the IP, and any custom WSAL keys your site has registered. From there filters and saved views are no different from working with WordPress posts in the same admin.
The result is the audit workflow most security teams already wish WP Activity Log had: pin a view for failed logins in the last 24 hours, another for plugin and theme changes this week, another for role escalations across all roles. Switch between them with a click rather than rebuilding searches each time, and export the exact column set you need for a compliance review.
Workflow
From WSAL tables to a working audit grid
Point at WSAL
wp_wsal_occurrences. SleekView detects the table and offers each native column — severity, alert code, user, IP, created-on — as a candidate field.
Join metadata
wp_wsal_metadata join so context keys promote into named columns. Object IDs, post titles, plugin slugs, and custom WSAL keys all become first-class fields you can sort and filter on.
Pin audit views
Annotate and export
Sample columns
A typical WP Activity Log audit view
wp_wsal_occurrences, wp_wsal_metadata
| When | User | Event | Object | IP | Severity |
|---|---|---|---|---|---|
| Today 09:14 | alice | Logged in | — | 203.0.113.4 | Info |
| Today 09:42 | bob | Edited post | Pricing page | 203.0.113.5 | Warning |
| Today 10:01 | unknown | Failed login x5 | wp-login.php | 198.51.100.7 | Critical |
| Today 10:30 | carol | Activated plugin | Yoast SEO | 203.0.113.6 | Warning |
Comparison
Default WP Activity Log admin vs SleekView
Default WP Activity Log admin
- The default log viewer is fast but its filters are fixed to predefined columns.
-
Custom WSAL metadata in
wp_wsal_metadatais not directly filterable. - Saved searches are limited and do not span event types and user roles together.
- Bulk archiving or tagging events is not part of the free workflow.
- Exports are CSV-only with no choice of which fields to include.
SleekView
- Joins occurrences with their pivoted metadata so each event row carries every relevant field.
- Inline tag, archive, or comment events without leaving the grid.
- Filter by event code, severity, role, IP, or any metadata key and save the view.
- Bulk acknowledge or export filtered events for compliance reports.
-
Pin views like
failed logins last 24horplugin changes this week.
Features
What SleekView gives you for WP Activity Log
Joined metadata
Promotes every key from wp_wsal_metadata onto the occurrence row. Object titles, plugin slugs, and custom alert keys become first-class fields you can filter and sort.
Compliance views
Pin reusable views per audit need — failed logins, plugin changes, role escalations, option edits. Each view remembers filters, columns, and sort order so any reviewer can reopen them.
Inline annotations
Tag events as reviewed, attach an internal note, or archive false positives directly from the row so investigations and decisions stay attached to the audit record.
Audience
Who uses SleekView for WP Activity Log
Security teams
Hunt suspicious activity by combining alert code, severity, IP range, and user role in one filter. Save patterns for recurring threat reviews and triage on a fixed cadence.
Compliance officers
Map saved views to specific audit checklist items — access reviews, plugin changes, configuration edits — and export the exact columns evidence requires for SOC 2 or ISO 27001.
Site admins
Investigate user reports without learning the WSAL data model. Filter by user and date, scan the metadata fields, and respond with a precise answer in minutes.
The bigger picture
Why audit logs need real query power
Audit logs only earn their keep when someone can answer a specific question with them: who changed the permalinks last month, which IP triggered five failed logins before that 3am login, which admin activated the plugin that broke checkout. WP Activity Log captures that data faithfully, but a fixed-column viewer makes every question feel like a fresh search. Compliance frameworks like SOC 2 and ISO 27001 expect repeatable, evidence-based answers, not screenshots of one-off filters.
The metadata pivot in wp_wsal_metadata is where the interesting fields live — object titles, plugin slugs, role names, custom alert keys — and a default UI cannot promote them to first-class columns without code. Treating WSAL data as a real grid changes the tempo of investigations: pin the views your team revisits weekly, share them with auditors, and stop rebuilding searches every time something breaks. The audit log becomes a tool, not a transcript.
Questions
Common questions about SleekView for WP Activity Log
No. SleekView is read-only against the WSAL schema by default. It queries wp_wsal_occurrences and joins wp_wsal_metadata for display, but the plugin continues to write events through its own pipeline. Annotations and tags applied through SleekView are stored separately so the WSAL audit chain stays intact.
Yes. Any key written to wp_wsal_metadata — whether by WSAL itself, an add-on, or a custom alert you register — can be promoted to a column. Once it is a column it behaves like any other field: sort, filter, group, or include it in saved views and CSV exports.
WP Activity Log Premium can write to a separate database. SleekView reads through the same connection definition, so if WSAL is configured to log to an external table, point SleekView at that connection and the grid stays consistent with the source of truth.
 Yes. Filtered rows export with the exact columns visible on screen, including any custom metadata fields you have promoted. Exports respect the active filter, the sort order, and the pagination range, so the file matches what the reviewer signed off on.
 SleekView paginates server-side and uses the indexes WSAL already maintains on occurrence ID, alert code, and user ID. Logs with millions of rows stay responsive because the grid never tries to load the whole dataset; it requests one page at a time with the active filter.
 Yes. SleekView respects the capability checks WSAL defines, so only users with permission to view the activity log see the grid. You can layer additional capability checks per saved view to limit who can open compliance-sensitive filters.
 SleekView does not replace WSAL's alert engine, but saved views work as a stable target for scheduled reports. Pair a view like Failed logins last 24h with a CSV export on a cron and route it to your security inbox or SIEM, while WSAL keeps real-time alerting where it belongs.
 The Reports add-on is good for scheduled summaries with predefined templates. SleekView covers the day-to-day investigation step before reports — exploring the data, discovering the right filter, then locking it into a view. The two complement each other: explore in SleekView, then promote to a scheduled WSAL report when the pattern is stable.
 Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkout