Marketing built a training completion tracker

“It's read-only except for updates.”— IT Service Desk

Reason:

Mainly because the automation sends an email asking someone to do it manually. With a roadmap in the README, last touched 209 days ago.

Built by:

Marco, a team lead

Build time:

4 hours 25 minutes

Built with:

Google Apps Script

Database:

Notion, with one row per customer

Authentication:

the production token is in a Jira ticket

Deployment:

on the marketing website's server, somehow

Responsible:

Petra, because their email address is in the config

Documentation:

none whatsoever

Security situation:

the database is reachable from the public internet

Future disaster:

It will outlive the vendor that was supposed to replace it.

Age: 3.6 years · originally expected to last 14 days · 3 owners so far · survived 3 reorganisations · last meaningful change 420 days ago

Rated rare mostly because: 794 users, alive 93x longer than intended, 2 accidental connections.