← back to portfolio

An IT platform that never forgets a ticket, a server, or a warranty

Next.js PostgreSQL ITSM Monitoring

An internal IT operations platform combining three things that usually live in three separate tools: a helpdesk with real SLA enforcement, uptime monitoring for every internal platform, and a hardware and software asset registry with warranty and licence expiry alerting.

The problem

IT requests arrived by chat, by shoulder tap, and by email, and vanished the same way. Nobody knew if the file server was slow or down. Warranties expired silently until a dead laptop turned out to be three weeks out of coverage. The organisation needed one place where a ticket cannot be forgotten, a degraded service cannot go unnoticed, and an expiring warranty announces itself in advance.

The approach

Dashboard with open ticket counts, SLA breaches, platform status and upcoming warranty expiries
One dashboard — open tickets, SLA breaches, live platform status, and warranties about to expire
Platform monitoring table with up and degraded statuses, response times and uptime percentages
Per-platform health checks — status, response time, and uptime percentage over 30 days

Built with Next.js server components, PostgreSQL with Drizzle, and Microsoft Entra sign-in, with alerts delivered by email and Teams. Three roles keep it simple: staff raise and follow tickets, IT operations work them, admins own the rules.

The outcome

Requests stopped vanishing, because chat and shoulder taps got replaced by a queue with countdown timers that someone owns. Outages became something IT tells the team about, not the other way around. And procurement got ahead of hardware failures because the platform starts nagging a month before a warranty dies.

What I learned

The alert log matters more than the alert. The first version sent notifications directly, and a worker restart could double-send or lose them. Writing the alert to a log first, then delivering from the log with deduplication, made the whole system boring and trustworthy, which is exactly what an IT platform should be.