The current step doesn't help in this case; there are hundreds of users that could be assigned the same step.

I'm trying to help my Process Admins/Business Managers to support their processes. When Jane quits, and all her tasks need to be assigned to Suzie, they don't have a reasonable way to find Jane's tasks.

We have same situations - there are two ways you can handle this:

1. Easy but long way

Remove Jane's license and wait for the Monitor to catch them all then reassign them to Suzie.

2. Difficult but short way

I don't know how complex your processes are but you can use a combination of these two SQL queries to get what you need:

First you will get all In Progress Instances

--find all Instances that are marked as "In Progress"

select process_id, title, bp_instance_id, start_date
FROM cf_bp_main_instances
where status = '1' 

Then you can search for Jane's name in the User Tasks of all processes

--change Jane's name or use a token

SELECT process_id, step_id, definition_json, name
FROM cf_bp_steps
WHERE step_type = 'userTask' AND is_inactive = 0 AND is_deleted = 0 and definition_json like '%Jane%'
ORDER BY process_id, step_id

 Optional - you can use workflow to accomplish this report, use the Custom Query action to find this information. (You can even join these two queries into one for more comprehensive results but I broke it out in steps) Then you can email yourself the report of all In Progress Instance ID numbers that could potentially involve Jane.

 

I started using the 2nd query to find all places where I have to replace someone's name when they leave because auditing it is so difficult when you have over 100 processes. As for in progress instances, I usually disable the license of the person who left and let the Monitor catch them then reassign as they get to the person who left. In my situation it is easier than reassigning each one immediately because of timers.

Hope that helps!