What is best way to determine if a task was performed by a proxy user. Or PLEASE ADD Task_ID to the
The audit log doesn't have the TASK_ID as a column so the only way that I have come up with to determine if a task was completed by a proxy user is this:
SQL Server query for a specific bp
select al.userid, al.proxyuserid, wft.end_date, al.eventtime, abs(convert(float,al.eventtime ) - convert(float,wft.end_date)) as timeDiff
FROM sys_wf_process_view wfp
INNER JOIN sys_wf_task_view wft ON wfp.id = wft.process_id
INNER JOIN unifier_auditlog al on al.SOURCEID = wfp.source_id and al.sourcetype=wfp.bp_type and wft.action_name = al.description and wft.assignee_id = al.userid and abs(convert(float,al.eventtime ) - convert(float,wft.end_date)) <0.0009