I built a PowerShell-driven asset-reporting system deployed to every Windows endpoint via Group Policy — machines report their hardware and system data to a central MySQL database for real-time inventory visibility, with hooks for future SNMP and network telemetry.
An Inventory Nobody Could Trust
Knowing exactly what hardware was deployed where meant spreadsheets that were stale the day they were made. The task was to make every Windows machine report itself — automatically, on a schedule, into one place you could actually query.
What I Delivered
PowerShell asset reporting
Built a PowerShell system that collects hardware and system data per machine.
Deployed via Group Policy
Rolled it out to every Windows endpoint through Group Policy.
Central MySQL inventory
Landed all reports in a central MySQL database for real-time visibility.
Ready for SNMP telemetry
Laid groundwork for future SNMP and network telemetry integration.
Skills & Tools
The stack behind this build — tap any to see related work.
The Impact
Every Windows endpoint now self-reports its hardware and system data to a central MySQL inventory in real time — deployed hands-off via Group Policy, and ready to extend into SNMP and network telemetry.
Make the Fleet Report Itself
A manual inventory is wrong the moment you finish it. Group-Policy-deploying a self-reporting agent turned asset tracking from a chore into a live database — the difference between guessing and knowing.
Image credits: “Dell PowerScale F600 nodes in storage cluster” by Btrs (CC BY-SA 4.0)
