Jira License 'Reclaim'

Question

So we are a small team. About 14 in our IT team. Pretty much everyone in the company uses email to submit helpdesk tickets. There's been a few times where people have logged in, taken up a licence, and have not logged in since. So 43/50 of our licenses are taken up, when ~15 of those users have not logged on for months.

Ideally I would like Jira just to "forget" they ever logged in and get that license back. Making them inactive will prevent them from creating tickets, which is not my intention. When a user logs in, they are added to the "users" group, which is set by default to allow them to login to the application. I want this to be allowed, but just want to remove users from that group again like they are a new user.

I have tried removing the user manually from the groups, but then if they ever try logging in again (which I want) it will come up with "You do not have a permission to log in."

Nic Brough -Adaptavist- · Answer

The answer is still the same.

Do not do this in the database without stopping Jira, taking a complete full backup, and restoring that to a test system to prove it was valid.

emards · Answer

Hello

Is this answer still valid?

I would like to do the exact same thing.

Also I understand that this is done by running a script in the DB.

Can I find the query that does it ?

Best Regards

Sebastien EMARD

Nic Brough -Adaptavist- · Answer

That's correct - you need to choose to deactivate a person.   And if you later decide you want them to create issues again, you'll need to reactivate them.

I've scripted stuff that does things like "last login > 3 months ago, deactivate" and "deactivate because an invalid email address means they've left even though HR are probably committing data retention crimes by destroying their email addresses"

But you have to actively choose to maintain your users like this.  Your users aren't taking up licences for no reason, they're doing it because you choose to let them.