# Historical Transaction Groups as a general logging facility

**URL:** <https://forum.inductiveautomation.com/t/historical-transaction-groups-as-a-general-logging-facility/66416>\
**Category:** Ignition\
**Created:** [November 12, 2022, 2:38am UTC](https://forum.inductiveautomation.com/t/historical-transaction-groups-as-a-general-logging-facility/66416 "2022-11-12T02:38:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fred\_Morris](https://avatars.discourse-cdn.com/v4/letter/f/ce73a5/32.png) [@Fred\_Morris](https://forum.inductiveautomation.com/u/Fred_Morris)\
**Post date:** [November 12, 2022, 2:38am UTC](https://forum.inductiveautomation.com/t/historical-transaction-groups-as-a-general-logging-facility/66416/1 "2022-11-12T02:38:21Z")

</div>

Simply put _Historical Transaction Groups_ are a general auditing / logging facility except for the fact that they don't seem to have the capability to send to a general logging facility (only to a SQL database). It's certainly within my power to emulate a database and use an existing SQL connector.

I'm thinking of something which writes line-oriented JSON to a UDP port, although a TCP connection would do. Am I missing something?

---

<div class="post-metadata">

**Author:** ![Fred\_Morris](https://avatars.discourse-cdn.com/v4/letter/f/ce73a5/32.png) [@Fred\_Morris](https://forum.inductiveautomation.com/u/Fred_Morris)\
**Post date:** [November 14, 2022, 12:55am UTC](https://forum.inductiveautomation.com/t/historical-transaction-groups-as-a-general-logging-facility/66416/2 "2022-11-14T00:55:14Z")

</div>

After some monkeying around with _MariaDB_ I stumbled on this:

```auto
  use test;
  create table JsonTable ( a_str varchar(32), a_int int, a_float double(12,4) )
  engine=CONNECT table_type=JSON option_list='pretty=0' lrecl=128;

```

which when given

```auto
  insert into JsonTable values ('bar', 43, 3.14);

```

produces

```auto
  {"a_str":"bar","a_int":43,"a_float":3.1400}

```