Can anyone point me in the a direction to learn to use this plugin (or perhaps the SQLite more generally)? I have read the plugin wiki entry, but I think I may need to move to something more general perhaps to working with SQL databases.
I would like to create a way to receive an email of a sort of "system report" on all monitored devices/variables.
For example, if an alarm event happened, I would get an email with tables of all the zones (perhaps last 5 changes or something), as well as the keypad device's last 5 states (or both LCD lines or whatever).
Once a month, I'd like to have Indigo send an email containing tables of perhaps the last 10 state changes of all devices and variables.
Maybe this is beyond the scope of indigo/SQLite/this plugin, but I figured I'd throw this out to the superusers on the forum.
Thanks