Hi,

For point 1, I think you can use Report SmartObjects to accomplish this ((i.e. Activity Instance and Activity Instance Destination).

I'm not sure that you will need a SQL query for this. These SmartObjects are under Workflow General category (SmartObject Service Tester tool > SmartObject Explorer > Workflow Reports > Worklow General)

Thanks you for your reply. 

I am actually working on a business report , thats why I am trying to find out the SQL tables/views. 

My report should look like this. Can anybody please help me t find out the SQL tables ??.

Hi kghosh,

I believe the tables listed below contain the information you are looking for.

1. [K2].[ServerLog].[ActInstDest]

• StartDate: Date and time when the activity was started


• User: Current assigned user

2. [K2].[ServerLog].[ProcInst]

• Originator: Originator of workflow instance


• StartDate: Start date of workflow instance

3. [K2].[Server].[ActionActInstRights] (For active instances)

• This table returns all assigned users (original destination and delegated/redirected) for the workflow instance/activity


• The ‘ActionerID’ column corresponds to the ‘ID’ column in the iK2].iServer].SActioner] table so you can obtain the name of the assigned user.

4. iK2].iServerLog].vActInstSlot] (For completed instances)

• User: Final user who actioned on the task


• StartDate: Date and time when task was assigned to the user


• EndDate: Date and time when task was actioned by the user

Hope this helps. 

K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.