MYOB Exo – Data Auditing – SessionIDs

A simple audit trigger to log every global identifier consumed in Exo. Note, this is going to be a lot of logged information.

if not exists (select 1 from sys.tables where name='X_SESSIONS')
	BEGIN
		CREATE TABLE X_SESSIONS ( TABLENAME VARCHAR(50),FIELDNAME VARCHAR(50),ID INT,STAFFNO INT DEFAULT [dbo].[FN_GET_STAFF_NO](), TIMESTAMPED DATETIME DEFAULT GETDATE())
	END
IF NOT EXISTS (select 1 from sys.objects where name like 'X_IDENTIFIERS_SESSION_LOGGER' AND TYPE='TR')
	BEGIN
EXEC ('CREATE TRIGGER X_IDENTIFIERS_SESSION_LOGGER 
	ON IDENTIFIERS
	FOR UPDATE
--AUTHOR:	Will Howard, 20190208
--PURPOSE:	Log who enters every transaction.

AS
BEGIN
	INSERT INTO X_SESSIONS (TABLENAME,FIELDNAME,ID)
	SELECT TABLENAME,FIELDNAME,ID from deleted
END')
	END