Which database table have a records of all the completed workflow instances

Hi team,

Could you please help which database table have the records of all the completed workflow instances?

I believe that the active workflow instance tables are:

[K2].[ServerLog].[ProcInst]

[K2].[ServerLog].[ProcInstData]

thanks and much appreciated for your help.

Page 1 / 1

@samarm

For Completed process instances:

SELECT * FROM [K2].[ServerLog].[ProcInst] WHERE [Status] = 3

Status = 3 would be from:

SELECT * FROM [K2].[ServerLog].[Status] WHERE [GroupName] = ‘Process’

“Active” workflow instances are usually in the:

SELECT * FROM [K2].[Server].[ProcInst]

If you are looking for some ERDs, there are some available at:

Great and thank you so much for your help.