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

Still need help?

The Atlassian Community is here for you.

Ask the community


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


  • 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?

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