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