Welcome to Smart Home Forum by FIBARO
Dear Guest,
as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.
As a member you can:
- Start new topics and reply to others
- Follow topics and users to get email updates
- Get your own profile page and make new friends
- Send personal messages
- ... and learn a lot about our system!
Regards,
Smart Home Forum by FIBARO Team
Search the Community
Showing results for tags 'Event Log SQL'.
Found 1 result
-
Hi At present, I am running 4.033 and have always found that the Event Panel does not hold sufficient history. At max, it seems to hold 2 days worth of data. While trying to scroll thru 2 days worth of events, I find that the Event Panel is non respondant some times. This is wholly insufficient for creating any analytics on temperature/humidity history as well as other alerts. I am sure it would be possible to read this information into a SQL database or even access and then we could use it for creating more analytics. I raised a ticket with [email protected] and their answer was plain and simple. "You cannot check these data. You can check it in Event Panel, or Consumption". Is anyone aware of any ways of running a batch that I can setup which would query this info using LUA and then dumping it into a SQL table? Thanks Raj
