Combine audit log data audit_events with tag data

Ignition
1

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

2

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

3

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.

4

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

1 Like