Need SQL query for pulling

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

We need query for extracting the duplicate records/tasks created in UI. Please find the attached screenshot for reference.

Environment

Release : 14.2

Component : GovernanceMinder(Role & Compliance Manager)

Resolution

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;