# Combine audit log data audit\_events with tag data

**URL:** <https://forum.inductiveautomation.com/t/combine-audit-log-data-audit-events-with-tag-data/38179>\
**Category:** Ignition\
**Tags:** database\
**Created:** [August 28, 2020, 8:12pm UTC](https://forum.inductiveautomation.com/t/combine-audit-log-data-audit-events-with-tag-data/38179 "2020-08-28T20:12:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![michael.benson](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@michael.benson](https://forum.inductiveautomation.com/u/michael.benson)\
**Post date:** [August 28, 2020, 8:12pm UTC](https://forum.inductiveautomation.com/t/combine-audit-log-data-audit-events-with-tag-data/38179/1 "2020-08-28T20:12:03Z")

</div>

I have enabled the Audit Log on so it tracking all the users activities

What I want to do is query that database(audit\_events) and do an “INNER JOIN” this table with the internal tag database to get the tags documentation

SELECT \*

FROM audit\_events

INNER JOIN sometagDatabase

ON audit\_events.action\_target = sometagDatabase.tagname;

at the end i want to display the audit log with the tag documentation

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [August 28, 2020, 8:26pm UTC](https://forum.inductiveautomation.com/t/combine-audit-log-data-audit-events-with-tag-data/38179/2 "2020-08-28T20:26:23Z")

</div>

You can’t join across different database connections, sorry. You’ll have to script the lookups on one side or the other.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 28, 2020, 8:31pm UTC](https://forum.inductiveautomation.com/t/combine-audit-log-data-audit-events-with-tag-data/38179/3 "2020-08-28T20:31:43Z")

</div>

I haven’t tried this, but can you change your audit log configuration to log to the same database where your tag info is? Then you could join the tables in your query.

---

<div class="post-metadata">

**Author:** ![michael.benson](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@michael.benson](https://forum.inductiveautomation.com/u/michael.benson)\
**Post date:** [August 28, 2020, 8:45pm UTC](https://forum.inductiveautomation.com/t/combine-audit-log-data-audit-events-with-tag-data/38179/4 "2020-08-28T20:45:49Z")

</div>

i think this is where i hit the wall. the tags are internal to ignition (Standard Tag Provider)