Audit 1.10.0
What is in this release
| Count | Summary | |
|---|---|---|
| Fix | 11 | Deletion/creation listing queries returned no results: joins dropped…; Duplicate rows and blank "Deleted by"/"Initiator" values caused by…; Inflated statistics from join fan-out: byte totals, download counts…; and 8 more |
Fixes
- Deletion/creation listing queries returned no results: joins dropped events when the related creation event or session predated log collection, now LEFT JOINs across ~25 queries
- Duplicate rows and blank "Deleted by"/"Initiator" values caused by empty-user session entries (20 queries)
- Inflated statistics from join fan-out: byte totals, download counts, and per-team/user aggregates could be multiplied
- Queries that always errored: Escrow User Actions Received, Libvirt Host Count, User Access Audit, User Actions Performed
- Filters silently applied to the wrong table in multi-table joins (stats-by-day deletion legs, team downloads, seclevel projects)
- Wrong values displayed: column names instead of values, Success flag as file type, key retrievals labeled as key additions
- Faulty NOT-IN/date logic that zeroed member counts, hid live teams/inboxes/seclevels, and listed deleted ones
- Stats reports listed every date in log history and missed failed-vs-successful event distinctions; date ranges and Success filters now applied consistently
- Non-Escrow Users used the wrong evidence table; dead UI filter parameters removed or wired up
- Team classification stats attribute to current team membership; Project Resource Pairs shows current tags (declassified files drop out); Drive Actions covers all five event types; Team Quotas shows current limits; stats domains now include users/projects predating log collection
- Footer was changed to have copyright year render dynamically