Finding all the workflows which are routed to specific group

[Anusha Dande]

Hi

Anyone can help to find all the workflows which are routing to specific groups or task activities, we have new task to replace the group in all the workflows as currently groups are consolidating.  workflows or catalog item names are not given.

Thank you

[Ankur Bawiskar]

@Anusha Dande 

So basically you want to identify which all workflows are using ABC group name or ABC group sysId so that you can replace with other Group?

check this article

Finding references / sys_ids in Workflows 

If yes then look at the sys_variable_value table. Simply look for Value contains <your_sys_id> of your group.

-> The record(s) returned, contain the ID field, which references the Workflow Activity the Values record is attached to. Opening the Workflow Activity wf_activity, would also give you the Workflow you are after [Field: Workflow version]

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Anusha Dande 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Anusha Dande]

Hi Ankur,

I still don't understand how to get the list of workflows which are having specific groups (ex: ABC) 

Thank you

Anusha

[Ankur Bawiskar]

@Anusha Dande 

seems you didn't go through the link properly

it clearly gives you what you want

it gives you the workflow version which has any activity using that sysId

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Najmuddin Mohd]

Hello @Anusha Dande ,

My approach would be to go the complete table, if it's Catlog items, the Assignment group is set on the RITM, then sc_req_item.LIST or if the Assignment group is set on Catalog tasks, then sc_task.LIST and filter with Assignment group with your current group.

By this, you can get all the RITMs to whom this Assignment group is added. 
On ScTask, you can bring the Parent RITM on the list layout and get the Catalog items.

If the above information helps you, Kindly mark it as Helpful and Accept the solution.
Regards,
Najmuddin