Logging some datas and building a dashboard

I want to get some datas from my device logs. I want a service to connect my linux devices and run a given command then get result of this command and put in mysql. There are 20 devices but i can easily add when program is finished.

Also i need a dashboard which shows daily results of my devices. Showing a monthly view is enough. Day 1 to Day31.

Devices are lines and columns are days.

I will give all connection details and running commands for all machines