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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.