Here is a SQL to get last login dateTime in mills:
declare @startDate datetime = '1970-1-1'; Select cwd_user.display_name as 'user name' , cwd_user_attributes.attribute_value , case when cwd_user_attributes.attribute_value is not null then CAST( dateaDD(SECOND, CAST(cwd_user_attributes.attribute_value as bigint)/1000, @startDate ) as DATE) else '' end as 'last login date' from cwd_user left join cwd_user_attributes on cwd_user.ID = cwd_user_attributes.user_id and cwd_user_attributes.attribute_name = 'login.lastLoginMillis'
I suspect that the reason you are looking for a list of users who have not logged in the system is so that you can go in and deactivate them from your system. You may like to review this plugin which enables you to do this efficiently from within the application. https://marketplace.atlassian.com/plugins/com.riadalabs.jira.plugins.userdeactivator/server/overview
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG