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
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
