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

[RichardA]

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 !!

[Robert Wen_Cprime_]

Jira licensing is allocated on a per-user basis (membership in a product access group).  It's not allocated/deallocated at user logon/logout.

[RichardA]

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.

[Robert Wen_Cprime_]

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]

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?