The Management Assistant built an asset register for 400 laptops

“It's not indexed.”— Marco, The Management Assistant

Reason:

Honestly? Because the process requires signatures from 3 people. With 82 users and zero documentation.

Built by:

Marco, someone from Procurement

Build time:

7 evenings

Built with:

Google Apps Script

Database:

Firebase with the admin SDK key committed to Git

Authentication:

the browser says "Not Secure", but only in red

Deployment:

restarted manually every Friday

Responsible:

Jens, who only knows the database

Documentation:

an architecture diagram containing a box labelled "magic happens here"

Security situation:

the threat model is "why would anyone attack us?"

Future disaster:

It will hold the only copy of Invoices_Q3.xlsm.

Age: 23 days · originally expected to last 2 months · 2 owners so far · last meaningful change 23 days ago · original builder left 42 days ago

Rated rare mostly because: 196 users, €223k per year, 5 departments depend on it.