How do I find all the workflow catalog tasks assigned to a specific assignment group?

[Brent Cox]

We are in the middle of re-designing our workflows and our assignment groups to add 3rd party support. Simply put, I need to find all of the catalog items that have an associated workflow that assigns a TASK to a specific assignment group. Is there any way to run a report to find this? 

[sushantmalsure]

Hi Brent

Can you hit following URL  

https://<Instance_Name>.service-now.com/sc_task_list.do?sysparm_query=request_item.cat_item.workflow...

Replace instance Name with your instance name and Name of Workflow with actual workflow name you are looking at.

This will return you list of sc_task associated with specified workflow.

You can also have the same list for Catalog items:

https://<Instance_Name>.service-now.com/sc_req_item_list.do?sysparm_query=cat_item.workflow.nameSTARTSWITH<NameOfWorkflow>

Now you can add, Request , Request Item , Workflow field as column to the list and also add Assignment group field.

This list view will give you idea of what you are looking for and further to that you can create a report on it with same filter criteria.

[Brent Cox]

Hello Sushant, 

I think perhaps I wasn't clear in what I was looking for. I am not trying to see ALL of the catalog tasks created for a specific assignment group, only the workflows that have a catalog task going to a specific assignment group. I need to identify all workflows that need to be updated with the new 3rd party support group instead of the existing assignment group. 

Thanks

[sushantmalsure]

Ohh I see , now I get it.

Well I am not sure if following will be helpful but certainly can give you list of workflows where catalog task activity was used then you can filter it further for specific assignment group.

https://<instanceID>.service-now.com/wf_activity_list.do?sysparm_query=activity_definition%3D38891b6f0a0a0b1e00efdfdd77602027%5Eworkflow_version.published%3Dtrue&sysparm_view=

Note: replace instanceID with your instance id

[Rahul Talreja · Accepted solution]

Hi @Brent CoxCox,
Interesting, 
Considering you are using the "Catalog task" activity definition in your workflows to fill the assignment group through "Fulfilment group" option.
I request you to navigate on "/sys_variable_value_list.do?sysparm_query=variable%3Dd7f2bd33c0a801650021da8ff242a081%5E&sysparm_view="
This will filter out all the list of catalog task used in all workflows and from here, in list view you can check the value which is the assignment group.
Adjust the filters in the table as per your need (e.g.: if you are assigning the assignment group from different activity definition)
It was interesting, Thanks.
Hope this might solve your query.