Active Catalog Items Creating SC Tasks Assigned to Telecom

[LokeshwarRV]

Hi Team,

I'm trying to identify all active Catalog Items that are configured to create an SC Task assigned to the Telecom assignment group. Querying current sc_task records is not sufficient because the assignment group may have been changed after task creation.

I'm looking for a way to find the Catalog Items based on the original configuration (Flow Designer, Workflow, Catalog Task definitions, Task Templates, etc.) and determine the total number of Catalog Items that create SC Tasks with Telecom as the initial assignment group.

Any guidance on the best approach or tables to query would be appreciated. Thanks!

[Ankur Bawiskar]

@LokeshwarRV 

you will have to search somehow in the flow or workflows

check this link it helped me to some extent to identify group from flow

For workflows

1. Navigate to sys_variable_value Table

2. Copy Syd id of the Group you are trying to search in Workflow activities

3. Paste it in Value Column.

You will able to see all the workflow activities where the group is used.

for some more help for workflows check these links

background script to identify particular assignment group in all workflows and flow designers 

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