How can I get a list of users with duplicate accounts (and accounts SSO ID marked as Dupes)?

[vcotton]

Hello,

When a  user has duplicate accounts on the community (2 different SSO Id's), typically we mark one as a dupe after the SSO ID number. Now I want to create a report of all such SSO IDs and users. How can I do that?

Thanks!

[VarunGrazitti]

@vcotton Hi Vanitha, if not via the system, we can extract the list via API's and then create the report in excel.

[StanGromer · Accepted solution]

IIRC, our user report in admin has a column for it. If your user report in admin doesn’t have it, you should be able to ask Support to enable it (Ive learned there is all kinds of things they can add over the years to that report). 

[TedV]

Hi @vcotton ,

If one of the comments answered your question, would you mind marking it as an accepted solution, please?

Many thanks!