Skip to main content
Nintex Community Menu Bar

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?

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    [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!

Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie SettingsAccessibility statement