How to check for users who never logged into Confluence

Still need help?

The Atlassian Community is here for you.

Ask the community


There are times when the Confluence administration would like to see the users that never logged to the application for administrative purposes.


In order to see the users who never logged into Confluence, run the following query:

This was tested with MySQL and Confluence 5.8.x. Other databases may slightly differ the syntax.

select user_name from cwd_user where user_name not in
(SELECT cwd_user.user_name
FROM cwd_user, cwd_user_attribute
WHERE cwd_user_attribute.user_id =
AND cwd_user_attribute.attribute_name = 'lastAuthenticated');


It will display all synchronised users.


Last modified on Feb 26, 2016

Was this helpful?

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