We are running a multi-plant SCADA project on Ignition Perspective with Azure AD SSO authentication. We have an existing audit table idaa_t_audit_event that is populated automatically by Ignition's built-in audit profile whenever a user logs in or out. The table structure is as follows:
Ignition's built-in audit profile inserts a row with action = 'login' automatically on every session start. However, it does not populate the device_type column — that column was added by us manually via ALTER TABLE.
We want to know from which device type (mobile app / desktop browser) each user opened their Perspective session, and store that in the device_type column of idaa_t_audit_event against their login row.
How can I do it? Any guidance from the community would be greatly appreciated. Thank you!
