I am looking to save a bit of time. Instead of manually looking through each workflow to see what workflows are currently enabled and active in 6.9, does anyone have a SQL report that shows the active workflows? All of the different workpoint tables are a bit confusing and I've had difficulty putting this all together. This way, I can easily and safely clean up my environment.
Many thanks in advance.
David
T_av_cr_workflows will identify any workflows that are configured as approval or fulfillment workflows on a business source.
The only workflows not accounted for here are subprocess ones. Use this query to identify those mapped:
select wd.var_cvalue, (select name from wp_proc wp where wp.proc_ref=to_char(wd.var_cvalue)) as wfname
from wp_user_data wd where proc_id is not null and var_name like 'acm.process%' and to_char(var_cvalue) != '-1'