Ignition Edge Audit Log in Perspective

To view audit profile data from a perspective view, I simply create a new view and drag in a table from the prospective component pallet. I then try to bind the table's data property to a name query that returns all the information in the audit events. But it is not showing the namespace. I am aware that Edge doesn't have SQL. I can able to see the logs in the Edge Gateway. But I want to bring this information in the Runtime Session. Is there any way to bring Audit Logs in the designer for the Edge system?

Yes, a GUI script can use system.alarm.queryJournal() to retrieve journal entries to display.

Edit: Whoops! Wrong function!

Isn't this for alarm journal entries, and not auditing events stored in the AUDIT_EVENTS table in a Database

There is a system function for the audit logs too
https://docs.inductiveautomation.com/display/DOC81/system.util.queryAuditLog

Looks like this should work.

3 Likes

Hi,
Can we display the ignition logs in perspective views.

Yes. Look at the post directly above yours; system.util.queryAuditLog, which returns a dataset that can be displayed in the Table component.

Yeah. But to need display Gateway ignition logs what need to be change in first point, could you ping out.
1.data=system.util.queryAuditLog(auditProfileName='AuditLog', actorFilter='john', actionFilter='tag write')
2.event.source.parent.getComponent("Table").data=data`