Ever since Panic’s Status Board for iPad app came out I’ve wanted to have data from iStat Server appear in Status Board.
After finding that iStat Server stores its data in
/Library/Application Support/iStat Server/databases/local.db and that the SQLite database and all its data is not encrypted/obfuscated in any way, I figured it wouldn’t be too difficult to get the juicy data into some sexy Status Board graphs.
Using the PDO and SQLite libraries included with Mac OS X 10.8.3 I was able to get a connection to the database and pull out rows. Simply store this file anywhere on your Mac that’s accessible by the built-in web server.
Lo and behold, a graph is born:
The project is still in its infancy, with only a few different graphs. I plan on slowly adding more and more graphs and types. As of this post, the following graphs are possible:
ram_hour- RAM usage for the past 60 minutes
ram_day- RAM usage for the past 24 hours
cpu_hour- CPU usage for the past 60 minutes
cpu_day- CPU usage for the past 24 hours
load_hour- CPU load for the past 60 minutes
load_day- CPU load for the past 24 hours
temp_hour- Temp sensors for the past 60 minutes *new*
Update - 05/06/2013
Todays big update includes temp sensor monitoring so you can get more pretty graphs, like below.
If you’re checking 1 sensor, make your query string
&temps=TC0D, or for multiple sensors, do
&temps=TC0D,TC0H. If you have multiple temp sensors, they must be comma delimited. For the most up-to-date list of sensors, check the README in the GitHub repo.
Head over to the GitHub repo (linked above) to check out the new changes and get it set up on your Mac!