Can we get an enhancement report on K2Workspace to display a list of worklists that are assigned to inactive destinations (ex-employees), so workflow admin can redirect them?
SELECT distinct w.procinstid, name, p.folio
FROM [K2HostServer].[Identity].[Identity] i, [K2ServerLog].[ServerLog].[Worklist] w, [K2Server].[Server].[WorklistHeader] h,
[K2Server].[Server].[ProcInst] p
where FQN = [Destination] and enabled = 0
and h.procinstid = w.procinstid and p.id = w.procinstid
and w.status != 4
order by name
