Eportal Audit Trail query
I'm trying to fish some information out of the audittrail table via sql.
Actions taken by a user in Eportal to be precise. However this table returns the ePortal username value eg. sta001aff (UserRespon in AUDITTRAIL).
Does anyone know of a table that might contain this username value alongside the staff ID?
I'm wanting to return the staff name as part of my query rather than having to look at the resource passwords list in Facility.
I've looked in RESPASSWORDS and can see that has an encrypted value PwdData that is linked to the staff ID. Knowing my luck the username is scrambled in that.
Anyone managed to find what I'm after in the maze of Facility tables?