Script which checks for user accounts which are not used since X months - how to?

[Rumceisz]

Hi Everyone,

we'd check our user database and hihghlight those users that did not login since >1 year in JIRA. Do you have such script?

Thanks,
Rumi

[Deniz Oğuz]

if you have access to DB, following query should return last login time of users

SELECT cwd_user.user_name, cwd_user_attributes.lower_attribute_value from cwd_user LEFT OUTER JOIN cwd_user_attributes on cwd_user.id = cwd_user_attributes.user_id where cwd_user_attributes.attribute_name = 'login.lastLoginMillis';