As our user base grows I want to be able to find those users who haven't logged in for n months, so our numbers don't spiral out of control.
There doesn't seem to be any way to do this through the admin interface, eg. I can't sort the user list by when they last logged in or filter for it. Have I missed something and/or is it possible to find this information through API methods - again I haven't spotted a way but I'm not very familiar with the API.
As chance would have it, I provided this use case ("able to find those users who haven't logged in for n months") as a comment on this issue just a couple of days ago. The issue is requesting that the user list in the JIRA Admin UI be sortable. It had been closed as "won't fix". Now it has been re-opened. But you still might like to vote on it.
We do have OnDemand so sadly instructions to look in the database aren't very helpful.
Other things that would be helpful are being able to sort the users list by the column headings or find users who aren't in any group. both not possible currently. The addition of a JQL filter like we have for issues could be handy.
It seems the area of user management hasn't had any attention for a long time and the functionality is pretty limited for an Administrator trying to manage several hundred users.
The API can poll user information, however the last login info isn't available from the API directly. Technically, at this point you have two options:
1.) You can go through the USER MANAGEMENT page and manually check when the last time someone was logged in.
2.) Or you can wait until this feature request is implemented: https://jira.atlassian.com/browse/AOD-6779
How to get all inactive users?
includeInactive is deprecatred. Is there any workaround?
Have a look at this knowledge base article and a similar discussion thread...
Here is a Jira cloud addon developed by my company that allows you to search, filter and bulk delete users:
In addition, it allows you to search for inactive users (users who haven't login in a while) and perform some bulk operation.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events