Need SQL query for pulling
search cancel

Need SQL query for pulling

book

Article ID: 138993

calendar_today

Updated On:

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;