I do not have a trigger on column yet. Would creating a after update trigger and collecting the data the best way to create the report.

my concern with trigger was...

I created proxy account with windows account with valid permissions.

Its a scrubbing job. it takes a backup from production and restores it on development server and scrubs out the sensitive data for development.

spid went away after the server...

I checked nothing is running around that time. its around 12pm each day