Fetch Jira Server license and total user license details into confluence page

Question

Hi Team,

We are using Jira server instance 8.16.0 . my requirement is to get the total Jira Licenses (history) and how many jira user licenses are used as of now and the time when users are most logged in.

And need to put all the information on confluence page. we are using Oracle DB so either by DB query or any API or any script if possible.

Can anyone suggest me to do these things.

Thanks !!

RichardA_iqxvt3 · Answer

Thanks for the replay @Robert Wen_Cprime_ , I have executed this (<URL>rest/plugins/applications/1.0/installed/jira-software/license/) url, its working fine and its providing the details about how many total licenses were purchased.

but couldn't find API for the number of users that are members of a product access user group. can you pls suggest

And is there any luck if we execute query from DB side to get those list?

Robert Wen_Cprime_ · Answer

The first number is how many total licenses were purchased.  The second number is the number of users that are members of a product access user group (default is "Jira-software-users") and thus occupy a license.

You may have some luck with the Java API.  The reference is here: https://developer.atlassian.com/server/jira/platform/java-apis/

RichardA_iqxvt3 · Answer

Hi @Robert Wen_Cprime_ , I want to update license details on confluence page. Please find the screen shot for reference.

can you pls suggest me how to update those data into confluence page.

Thanks.