SQL query for to find Jira license limit

[Anoop K Baby]

Hi Team,

           I was looking for an SQL query to find actual license limit of the Jira license which we purchased, I know we can see the value from UI, but I am looking for a query to include it in an automation. Also please note, I am not looking for the active users limit or any used users count like one mentioned here -  https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-active-users-counting-towards-the-jira-application-license-278695452.html

Thanks,

AKB

[Nic Brough -Adaptavist-]

The limit is not stored in the database, so your SQL is going nowhere.

[Anoop K Baby]

So if that is the case, do we have any option to get it through any API calls. Or is there any option to get the value into some scripts?