CASE FILE 01 · FEATURED
Security Incident & Asset Tracker
- 01 / problem
- Small IT teams often track assets in spreadsheets and log incidents in chat, so nothing links a compromised host to the incident history behind it.
- 02 / approach
- Built a Java + JDBC console application on MariaDB with a relational schema linking Assets↔Incidents, a DAO layer for data access, and PreparedStatement used throughout to prevent SQL injection.
- 03 / outcome
- Assets and incidents are queryable together, with severity classification on every incident. Built and tested end to end on Kali Linux.
- 04 / what's next
- Add analyst-facing reporting queries and export incident timelines mapped to MITRE ATT&CK techniques.