SELECTED ANSWER
replied on April 26, 2023
Here's a start...
Query to see the list of teams - use this to determine the id number of the team:
SELECT *
FROM [LFForms].[dbo].[teams]
Once you know the team ID number, you can do a query like this to identify the User Tasks that reference that team ID number (in this example, I'm searching for ID # 12 - you can edit that on line 9):
SELECT
bp.[name] AS process_name,
step.[step_type],
step.[name] AS step_name,
[definition_json]
FROM [LFForms].[dbo].[cf_bp_steps] AS step
LEFT JOIN [LFForms].[dbo].[cf_bp_processes] AS bpp ON bpp.[process_id] = step.[process_id]
LEFT JOIN [LFForms].[dbo].[cf_business_processes] AS bp ON bp.[bp_id] = bpp.[bp_id]
WHERE [definition_json] LIKE '%"teamId":12%'
AND step.[is_deleted] = 0
AND bp.[is_deleted] = 0
This is tested on Forms Version 11.0.2212.30907 and SQL Server Management Studio versions 18.12.1