How to check for users who never logged into Jira
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.
There are times when the Jira 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 Jira, run the following query:
This was tested with PostgreSQL and Jira 8.20.2. Other databases may slightly differ the syntax.
SELECT LOWER_USER_NAME FROM CWD_USER WHERE LOWER_USER_NAME not in (SELECT CWD_USER.LOWER_USER_NAME FROM CWD_USER, CWD_USER_ATTRIBUTES WHERE CWD_USER_ATTRIBUTES.USER_ID = CWD_USER.ID AND CWD_USER_ATTRIBUTES.ATTRIBUTE_NAME = 'login.count');