Which K2 database table holds data regarding "sharing a task"

Hi AbdulRehman,

Depending on what version of K2 you are using typically you would find this information within the Activity Instance Audit SmartObject.

To get to the SmartObject:

• Open the SmartObject services tester tool


• Navigate to "SmartObject Explorer">WF Reports>Workflow General>Helper> Activity Instance Audit.


• Execute the “List Activity Instance Audit” method - you can execute the SmartObject with or without parameters


• In the table, under the “Audit Description” Column is where you’ll find the user’s details responsible for the share/redirect and the user who the task has been redirected/shared to. In other words both users will be listed in the column starting with the Originator and Targeted user.

If the SmartObject doesn't excist in the above mentioned diretory then you may have to first register an instance of the ServiceObject inside the SmartObject services tester tool:

• Navigate to ServiceObjects Explorer > WF Reports > Workflow General > Activity Instance Audit Service Object


• Right click and create SmartObject


• In the Publish SmartObject window, check that the name of the smart object the doesn’t exist, then assign it to the desired category then click Publish SmartObject


• Open K2 Workspace


• Click on the Report tab>Report Designer


• Click on the “Create Report” button


• In the create report wizard – Report info and type, enter a name for the report and select the Tabular Reports under the Report Type tab. Then click next.


• Under the create report wizard – Data Source, choose the Activity Instance Audit SmartObject your created in the previous steps then click next.


• In the create report wizard – Data layout, Drag and drop the columns you would like to see in the report from the left pane into the right – Audit Description should be one of them. Then click next


• In the create report wizard – Summarize the data, click next.


• In the create report wizard – Filter the data, click next.


• In the create report wizard – Report Parameters, click next.


• In the create report wizard – Finish, save the report in a desired category then you can view the report.

The destination user who have shared/redirected a task with a targeted user will be listed under the Audit Description column

I am sure following tables will help you with what you are looking for:

    1. Server.ActionActInstRights

    2. Server.ActionActInstShared

[Please mark this as answered if it helps resolve your issue]