Users that have never logged in and are in a specific group

[Tanya Gordon]

Hi,

I know this has been asked and discussed countless but I couldn't find the answer to answer this specific requirement. I need to be able to list the users that have never logged in and are members of a specific group.

Who can help me write this sql query? 

Thanks in advance to all!

Tanya

[Andrew]

Hi @Tanya Gordon ,

I check on my Jira, and see that new user haven't attr 'login.count'. 

So, in my case resolution look like this:

SELECT user_name FROM jiradb7.cwd_user where id not in (SELECT user_id FROM jiradb7.cwd_user_attributes where attribute_name='login.count');

[Andrew]

Hi @Tanya Gordon ,

Maybe it https://community.atlassian.com/t5/Jira-questions/Users-never-logged-in/qaq-p/447331