How do I query JIRA to get a list of user that have never logged

[Jeanne Howe]

We are using Crowd with JIRA to manage users. How do we query to find all users in the jira-users group that have never logged into JIRA?

We are JIRA 6.4 and Crowd 2.7

[Guilherme V. · Accepted solution]

Hi there,

You could try this one:

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

Cheers,