How to get a list of all "Unknown User" in Confluence

Still need help?

The Atlassian Community is here for you.

Ask the community

Purpose

This knowledge base will provide instructions on how to get a list of all the users that are displayed as "Unknown User" in Confluence.

Solution

  • Use the following SQL query

    SELECT * FROM user_mapping WHERE lower_username NOT IN (SELECT lower_user_name FROM cwd_user);
Related Content:


Last modified on Jan 25, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.