I wanted something to keep track of all the devices I had on my network. While installing Zabbix, I had to install MariaDB (MySQL), so I used that database to house the inventory of devices. This also uses PHP, jQuery and DataTables on the front end and Bash, Python and GO on the backend.
The scripts connect to and parse the data from my routers DHCP server logs. Then match that to DNS (running on 2 PiHoles), looks up the OUI of the MAC address for manufacturer and scans it’s ports looking for SSH, HTTP or HTTPS.
