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

Question

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_g4chs4 · Answer

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_g4chs4 · Answer

Hi @Tanya Gordon ,

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