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
Are you looking for what is calling the workflows at the top level or even sub processes? Top level is easy - t_av_crworkflows has the mappings of what request workflow to use for what source type
Hi Sean, Yes. I am looking to know at a high level all active top level and sub process workflows invoked. This way I can have a list of workflow names, and potentially if it's an Approval or Fulfillment related workflow.
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'
Sean you are amazing! The goal is to help all partners during migrations in environment where multiple people are creating workflows. Currently, we need to manually go through each workflow and right click on every respective object.
If I am not mistaken, this query looks at Change Requests that have already been submitted and then finds the workflow names that generated them. Is there a way to show all configured workflow names viable in the UI, irrespective if a change request has been created or not?
Also, could you help me understand why some name fields from wp_proc when are null? Should these just be filtered out too as well?
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'