I can read the alarmlog with sqlite3, but I don't understand the format and the meaning of the various tables. However, I think that the time is specified in milliseconds since January 1984.
How can I make query which list the alarms formatted correctly?
I assume I have a similar problem with AC_DataLog . It is of course fine that we can store values in a sqlite database, but it would be nice if we also could read these stored values.
👍
1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The timestamp used for alarm log is this: https://www.epochconverter.com/ldap
But I dont know how to convert it using sqlite3. It make it diffecult to do a query
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can read the alarmlog with sqlite3, but I don't understand the format and the meaning of the various tables. However, I think that the time is specified in milliseconds since January 1984.
How can I make query which list the alarms formatted correctly?
I assume I have a similar problem with AC_DataLog . It is of course fine that we can store values in a sqlite database, but it would be nice if we also could read these stored values.
The timestamp used for alarm log is this:
https://www.epochconverter.com/ldap
But I dont know how to convert it using sqlite3. It make it diffecult to do a query
more posts ...
Hi,
Just want to add my two cents.
I think reading back stored values from the AC_DataLog would be great!
Aliazzz