Page History

...

mysql> mysql> SELECT *, from_unixtime(`timestamp`/1000) FROM rs_event;

+----+-----------+----------+------------+---------------+-----------+------------+---------------------+----------+--------+---------------------------------+

| id | group     | edgeNode | device     | timestamp     | StringTag | BooleanTag | DateTag             | FloatTag | IntTag | from_unixtime(`timestamp`/1000) |

+----+-----------+----------+------------+---------------+-----------+------------+---------------------+----------+--------+---------------------------------+

|  1 | TestGroup | TestNode | TestDevice | 1532125999934 | Test      |          1 | 1969-12-31 00:00:00 |      2.1 |      1 | 2018-07-20 17:33:19.9340        |

|  2 | TestGroup | TestNode | NULL       | 1532126467393 | Test      |          1 | 1969-12-31 00:00:00 |      2.1 |      1 | 2018-07-20 17:41:07.3930        |

+----+-----------+----------+------------+---------------+-----------+------------+---------------------+----------+--------+---------------------------------+

2 rows in set (0.00 sec)

Additional Resources

• Inductive Automation's Ignition download with free trial
  • https://inductiveautomation.com/downloads/
• Azure Injector download with free trial
  • https://inductiveautomation.com/downloads/third-party-modules
• Questions about this tutorial?
  • Check out the Cirrus Link Forum: https://forum.cirrus-link.com/
  • Contact support: support@cirrus-link.com
• Sales questions
  • Email: sales@cirrus-link.com
  • Phone: +1 (844) 924-7787
•  About Cirrus Link
  • https://www.cirrus-link.com/about-us/