Query Default HS Energy Database

[DavidLiles]

Not sure if this is the appropriate forum or if I should ask in the scripting forum.... Today I installed an Aeotech Energy Meter (super easy) and am getting good data when I view the Energy option from the HS UI.

I would like to be able to query the database that is capturing the information with a script that is triggered from an Alexa voice command via the check_vcmd2.vb. I can parse the request to return the appropriate response/action. I'd like to be able to say, "Alexa, ask HS what today's kw usage is." or "Alxea, ask HS what today's kw cost is." and so forth. I'm already doing something similar for other actions and returning customized responses but am unclear as to what the database is and if there are any unique issues I need to be aware of.

[sparkman]

Hi David,

All of the HS database files are SQLite based and can be queried and accessed using vb.net sqlite libraries that HS installed. To look at the database to understand its structure, use SQLite Browser (https://sqlitebrowser.org/). I have a few scripts accessing the HS database, one example is here: https://forums.homeseer.com/forum/de...tions?t=187187. Hope that helps.

Cheers
Al

[DavidLiles]

Thanks sparkman, I'll check that out. What I've found in the user documentation regarding energy management is not overly informative.... but does lend well for a lot of trial and error... ha.