How to check for users who never logged into Jira
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
目的
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');