We need query for extracting the duplicate records/tasks created in UI. Please find the attached screenshot for reference.
Release : 14.2
Component : GovernanceMinder(Role & Compliance Manager)
The only time this is needed to be performed is when you are using GM workflows previous to v3 business workflows.
Query:
select ua.businessflowid, ua.owner, count(*) as total
from useractions ua
where ua.businessflowid = 30
group by ua.businessflowid, ua.owner, ua.mainentity, ua.secondaryentity
having count(*) > 1
order by ua.businessflowid, ua.owner, ua.mainentity, ua.secondaryentity;