Admin Dashboard: Live Platform Statistics

Release: v1.0.24

Overview

The Admin page (/dashboard/admin) now displays accurate, real-time statistics pulled directly from the database. Previously, all four summary stat cards were hardcoded to 0, giving administrators a misleading picture of the platform's state.

What the Admin Page Shows

The stat cards on the Admin page surface the following platform-wide counts:

Stat Card	Description
Total Organizations	Count of all registered organisations in the platform
Total Users	Count of all user accounts across every organisation
Active Subscriptions	Count of currently active subscription records
Audit Events	Count of all recorded audit log entries

Below the stat cards, the Audit Log section lists recent audit events pulled via trpc.audit.list.

How It Works

Each stat card is populated using a lightweight count() query via Drizzle ORM at page load time. No complex aggregations are performed — the queries are intentionally simple and fast.

The audit log follows the same data-fetching pattern established by the existing BatchJobsPanel component, ensuring consistency across the admin interface.

Who Can Access This Page

The Admin page is restricted to platform administrators. It is not visible to standard landlord users or organisation members.

Notes

• If a stat card displays 0, it now genuinely means there are no records of that type — not a missing data fetch.
• Audit log entries surface actions taken across the platform and are useful for compliance monitoring alongside HMRC Making Tax Digital obligations.