Get license usage history quarterly and fetch list active users with last login date.

Question

We are using Jira server instance 8.7.1. bitbucket server  -6.10.0, Confluence server - 7.4.0
I would like to find out two things,

1. Need help to get the quarterly usage of Licenses (history), we are using MSSQL DB so either by SQL query or any API if possible.

2. Need help to list active users in Jira, bitbucket and confluence with last login information. - any script, API, query for these.

Aron Gombas _Midori_ · Answer

Assuming that you manage the user accounts centrally (shared by the 3 applications), you can export the user accounts from Jira to Excel:

https://www.midori-global.com/products/better-excel-exporter-for-jira/server/documentation/user-export

Kurt Klinner · Answer

@karthik Panuganti

And for Bitbucket ...

https://confluence.atlassian.com/bitbucketserverkb/how-do-i-find-which-users-count-against-my-bitbucket-server-license-779171685.html

Cheers

Kurt

Kurt Klinner · Answer

@karthik Panuganti

Hi Karthik

welcome to the Atlassian community

For Jira please have a look to https://confluence.atlassian.com/jirakb/get-list-of-licensed-users-in-jira-server-278695452.html for Confluence https://confluence.atlassian.com/confkb/how-to-get-a-list-of-active-users-counting-towards-the-confluence-license-298978076.html might give you an idea how to get the relevant data. https://confluence.atlassian.com/confkb/how-to-identify-inactive-users-in-confluence-214335880.html can also be helpful.

Hope that helps

Cheers

Kurt