Duplicate user report | Community
Skip to main content
L
lmcintron
May 23, 2025
Solved

Duplicate user report

  • May 23, 2025
  • 2 replies
  • 462 views

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.

Best answer by William--

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.

2 replies

William--
Community Advisor
William--Community AdvisorAccepted solution
Community Advisor
May 26, 2025

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.

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf
    L
    lmcintronAuthor
    May 27, 2025

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

     

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    September 22, 2025

    @lmcintron we noticed your question and invite you to our [Workfront AMA] Ask Me Anything about Workfront System Smarts & Strategic Starts on Wed, Oct 29, 2025 | 9–10 AM PDT. Experts will answer questions on topics like: day-to-day system tasks, strategic planning, Reporting, Adoption, System Maintenance, Notifications, Governance, Roadmapping, and Custom Forms. Post your questions in advance to ensure they’re answered. Reminder: All AMAs are TEXT-ONLY—no video or recording. RSVP & submit questions in advance here: https://adobe.ly/46xKfHM 

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...