Duplicate user report

[lmcintron]

Does anyone know if there is a report that can be created showing any duplicate users in the system.   When we initially implemented Workfront, we used email addresses as their Federated ID's.  When we moved over to the Adobe Console, we had to change the federated IDs to match what we had in AD.  This created duplicate users in the system, and I would like to run a report listing those users.   

Any advice would be appreciated.  

Thank you.

[William-- · Accepted solution]

Have attempted duplicate reporting on many object types over the years and arrived at the conclusion that it isn't possible in WF reports. 

The good news is that it's fast and easy to export a user list to Excel from a user report and then use Excel to identify the duplicate values. A COUNTIF formula in a new column can return "TRUE" on the duplicates, and you can then filter against those rows.

[lmcintron]

Thank you for the response.  I was able to get what I needed and learned something new in the process.