Jira: How to generate email notification when you near your license limit

[Conal Curran]

We have an on prem version of Jira and are looking to generate an email alert when we near our license limit.

At the moment, we only know we've breached our license count when users have issues accessing Jira. We would like to be proactive and get an alert of sorts before the the license limit is breached.

Open to suggestions if there is a better way of getting this alert.

[Elifcan Cakmak · Accepted solution]

Hello,

Jira does not offer a default solution to this. But you can implement a custom script. 

First you can check your active user count from your db with the sql provided here:

https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-active-users-counting-towards-the-jira-application-license-278695452.html

Then you can write a script that compares the count of your user number to your license limit and sends an e-mail if the former is bigger than the later.

Regards,

[Conal Curran]

Excellent, thanks very much. I'll give it a try.

[Elifcan Cakmak]

You're welcome :) After you try it out, if it works for you, could you kindly accept the answer so that other people also see it is the solution? Thank you.