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
View originalYou’ll find this in the ServerLog.ActInstAudit table. Here is a good way to get it at for a specific folio:
SELECT aia.[Date],
aia.[User],
a.Name,
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
Thanks @tbyrne777 This query gave me exactly what I needed!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
