Hello,
I was able to figure out lock history from workflowlockhistory table.
Below is the screenshot and sql.
SQL... using GolfStream app
select a.Profilename, b. UserName,
(case cast(b.OriginID as varchar)
when '-999' then 'Import'
when '-32' then 'Adj'
when '-30' then 'Forms'
else cast(b.OriginID as varchar)
end) as 'Origin',
b.TimeStamp, b.IsLocked from WorkflowProfileHierarchy as a
left outer join workflowlockhistory as b
on a.ProfileKey = b.WFProfileID
and b.scenarioID = 0 and b.TimeID like '2011%'
where ProfileName like'%HS%Budget'
Order by a.ProfileName, b.TimeStamp desc
JC
