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

[Mugilan Sukumar]

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

[Dick]

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