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?
Page 1 / 1
You’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   cK2-SqlDev].iK2DEV].ServerLog.ProcInst pi
         JOIN eK2-SqlDev].cK2DEV].ServerLog.ActInst ai ON ai.ProcInstID = pi.ID
         JOIN tK2-SqlDev].rK2DEV].ServerLog.ActInstAudit aia ON aia.ProcInstID = ai.ProcInstID AND aia.ActInstID = ai.ID
         JOIN iK2-SqlDev]. K2DEV].ServerLog.Act a ON a.ID = ai.ActID
   WHERE   pi.Folio = @folio
Thanks @tbyrne777Â This query gave me exactly what I needed!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.