Server Health Statistics script
Today I wrote a script for gathering health statistics on my servers. It gets data from hddtemp and sensors and writes it to a MySQL table.
The script and how-to-use can be found on the wiki: http://wiki.welmers.net/en/Health2MySQL
The MySQL table can easily be analized by (web) scripts to graphs e.d., functionality I still need to write.
Things that already can be done is finding interresting issues like:
SELECT AVG(temp_cpu) FROM health WHERE datetime BETWEEN '2008-07-25 00:00:00' AND '2008-07-30 23:59:59'
SELECT MAX(temp_sda) FROM health
SELECT MIN(rpm_fan) FROM health