how to list of user in specific group and never logged in jira

Question

Kindly help us to find list of user in specific group and never logged in jira. we are using oracle database.

Dick · Answer

Hi @Mugilan Sukumar 
I don't know if this is still a pressing matter, nevertheless, this is the sql for a MS database, which should be good on oracle as well (or at least the majority of it)

use YOURJIRADATABASE
SELECT u.lower_user_name, u.created_date
FROM cwd_user u

WHERE u.active = '1'
AND u.lower_user_name IN (
  SELECT CWD_USER.LOWER_USER_NAME
  FROM CWD_USER
  WHERE LOWER_USER_NAME NOT IN (
      SELECT CWD_USER.LOWER_USER_NAME
      FROM CWD_USER
      JOIN CWD_USER_ATTRIBUTES
      ON CWD_USER_ATTRIBUTES.USER_ID = CWD_USER.ID
      WHERE CWD_USER_ATTRIBUTES.ATTRIBUTE_NAME = 'login.count'
    )
  )
Order by created_date asc;

I came across your query when looking for some knowledge. 
Kind regards,

Dick