Archived · 2025

Helpdesk scripts

Small automation scripts from my IT support days that saved hours of repetitive work.

SQL

1select device, last_seen
2from assets
3where last_seen < now()
4  - interval '30 days'
5order by last_seen;

Reports and clean-up jobs that turned a weekly manual chore into a scheduled task.