Welcome to our new forum
All users of the legacy CODESYS Forums, please create a new account at account.codesys.com. But make sure to use the same E-Mail address as in the old Forum. Then your posts will be matched. Close

How to read a sqlite log database? alarmlog or AC_DataLog

DavidBo
2020-03-28
2020-03-28
  • DavidBo - 2020-03-28

    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
    • DavidBo - 2020-03-28

      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

       
  • aliazzz

    aliazzz - 2020-03-28

    Hi,

    Just want to add my two cents.
    I think reading back stored values from the AC_DataLog would be great!

    Aliazzz

     

Log in to post a comment.