Workflow Audit History

[Mikki]

Hi

Does anyone know where all of the below information is stored? 

Thank you,

Mikki

[JackLacava]

Wild guess: the Workflow*History tables...? 😅

If you can find an Application Report that displays the data, you can typically dissect it in Design Mode, get to the data adapters and from there to the tables (or methods) that you need.

[Mikki]

Thank you. I did the reverse engineering like you said but only managed to get Certify step info and that without user info. Application report is using Method query so no idea where the data sits in table. I will look into Workflow History tables.

[Mikki]

Hi, 

I am happy to try out the functions. I tried below (took from one other thread in this forum) but didn't work

Dim wfstatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, mywfstep)
Dim logusername as String = wfstatus.LastExecutedStep.StepLogItems(0).UserName 

All I wanted is User name and time stamp of steps.