Ability to run an audit query on who ran a query that caused SPID blocking

Site and CPACS wants a way to audit who ran a problematics query.

select top 50000 row_number = identity(8), e.exam_ckey

into #base

from patient p

inner join examination e on e.pat_ckey = p.pat_ckey

inner join exam_sts_stat ss on ss.exam_ckey = e.exam_ckey and ss.sts_id = 10

inner join exam_procedure ep on ep.procedure_ckey = e.procedure_ckey

where ( upper(p.pat_name) like 'FIN%' )