How to check for users who never logged into Confluence
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
There are times when the Confluence administration would like to see the users that never logged to the application for administrative purposes.
Solution
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.
1
2
3
4
5
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 = cwd_user.id
AND cwd_user_attribute.attribute_name = 'lastAuthenticated');Note
It will display all synchronised users.
Was this helpful?