I’m a K2 admin for our company and I’m trying to figure out how I can determine the original destination for a task that has been redirected. I’m often asked who redirected a particular task to another user but I haven’t been able to find a way to see how the first user was. Is there a way to do this either from the Management Dashboard or from the database tables?
Best answer by tbyrne777
You’ll find this in the ServerLog.ActInstAudit table. Here is a good way to get it at for a specific folio:
aia.Descr AS 'Description'
FROM [K2-SqlDev].[K2DEV].ServerLog.ProcInst pi
JOIN [K2-SqlDev].[K2DEV].ServerLog.ActInst ai ON ai.ProcInstID = pi.ID
JOIN [K2-SqlDev].[K2DEV].ServerLog.ActInstAudit aia ON aia.ProcInstID = ai.ProcInstID AND aia.ActInstID = ai.ID
JOIN [K2-SqlDev].[K2DEV].ServerLog.Act a ON a.ID = ai.ActID
WHERE pi.Folio = @folio