Just curious if any of the Home Automation software out there has fairly easy to use, built in historical logging, trending and reporting.
On the back end, I would like to have a single database where I can add "devices" to log. The database would log on state change or by sample rate (say every 5 minutes). I would like to log Temperature, security sensors, insteon switch condition, etc.
On the front end, I would like an interface where I can easily create reports and graphs. Some of the reports or graphs might be:
* How long the lights were "on"
* Yesterdays (or last weeks, etc.) temperatures inside and outside
* When was the last time a security sensor was tripped
* Use your imagination...
Finally, once the graphs and or reports are setup, they could be automated and included in web pages or .net displays.
I imagine this exists and I just haven't found it.
Also, I need the software to handle Insteon, Aprilaire thermostats and Elk M1G connections.
Looking forward to feedback.
On the back end, I would like to have a single database where I can add "devices" to log. The database would log on state change or by sample rate (say every 5 minutes). I would like to log Temperature, security sensors, insteon switch condition, etc.
On the front end, I would like an interface where I can easily create reports and graphs. Some of the reports or graphs might be:
* How long the lights were "on"
* Yesterdays (or last weeks, etc.) temperatures inside and outside
* When was the last time a security sensor was tripped
* Use your imagination...
Finally, once the graphs and or reports are setup, they could be automated and included in web pages or .net displays.
I imagine this exists and I just haven't found it.
Also, I need the software to handle Insteon, Aprilaire thermostats and Elk M1G connections.
Looking forward to feedback.