Hi,
For this, in the dashboard page of theme, need to write queries to get data from local db.
How often do you wish to pull data from the various linux boxes? Perhaps a scheduled tasks will do.
How do you want the visiualization to be done? Have you selected a preferred charting library like charts js?