Hello, I have configured my audit profile and everything works. Now I want to add two things to my audit log; I want te computer name added to the table. In the configuration settings at the advanced settings the host for the query is filled in “ACTOR_HOST” but it doesn’t show up when I link the…

I generally use a DB query to get this info. It does not appear to be exposed in the built in function. SELECT * FROM audit_events You can filter on the ACTOR_HOST column in your query. Just beware, HOSTNAME can be in-accurate depending on the network environment. Our company uses a lot of lapt…

Okay I found how to add a date to the audit log by putting a “date range” object on the screen and linking the dates in the options of the audit log. Now I only need to find out how to get the PC name in the columns if anyone could help me with that it would be great!

Hello ryanjmclaughlin this works great. Except I need to manually be able to edit the dates. I have a “date range” on the screen with an SQL query I don’t think it’s possible to adjust the dates?

Easy! Check out the Dynamic Filters section on this page of the docs for a dynamic date example in SQL https://docs.inductiveautomation.com:8443/display/DOC79/SQL+Query+Binding

Thank you ryanjmclaughlin this worked!

Inductive Automation Forum

Audit log options

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled