Symptoms

Activity Instance Destination Smart Object
 

Diagnoses

Hello K2 Support,

I need to create Report in which I have to combine data from Activity Instance Destination Smart Object along with user defined Smart Object. I would like to know where the information of fields of Activity Instance Destination Smart Object is being used so I can write UNION Query and combine it with my Business Data and able to create Report.
 

Resolution

You can get the exact script by running a SQL Profiler trace.

You'll want to set the filters to only show the NTUserName of 'K2Service' or a LoginName of ''DOMANIN'K2Service. You'll also want to make sure that you select the 'TextData' column as output. Start the trace, fire of the smartobject, wait a few moments, and then stop the trace.

You'll be looking for exec sp_executesql N'WITH T_TempTable1] as (, and then the script will follow. You can highlight this row, and extract the event data.