It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Admin task: check user activity per license type to get an overview about license usage

As an administrator in a global company with a large user base, lots of projects and different JIRA license types (SD, Software) I need to keep track of the license count and the usage of licenses.

My wish: If one of my licensed users does not use the assigned license, I want to see it - to potentially take it away from the user to give the license to somebody else.

All my users can be at least in one of the following groups:

- JIRA Software User

- JIRA Service Desk Agent

- Jira Service Desk Customer

My problem is that the last logged in (last active) timestamp does not work for me as (as an example) an user could have created a ticket within a service desk project in a role as an (internal) customer - but never uses the software or core license she/he has been assigned for another project. --> That is what I want to see.

I can check some activity using JQL selecting issues (e.g. doing some pseudo counting) on an user by user level using something like 

'status changed to (closed) by (user1)' or 'assignee was in (user1)'

but I cannot get that as an overview about all my licensed users. (And doing this for hundreds of users is a bit cumbersome)

So my question is: Does anybody of you know a good way to keep track of the activity of each licensed user per license type?

Best regards

2 answers

2 accepted

If you are in server I suppose you could do some magic with a database query to search last activity per user per type of project. Unfortunately I'm not a DB guy who could help you build such query.

Within Jira I don't see it very likely to be possible

Thanks Hernan,

that was what I have feared that I will have to either go to database level - or script some REST calls using JQL statements for each user and use the total results value from the JSON result.

0 votes
Answer accepted

For the completeness:

Atlassian offers a plugin since ~Sept 2019 which seems to do what I was asking for.

Name of the Plugin: Centralized license visibility - you can find it on the market place.

Pre-Requisite is that you need Crowd Data Center with version > 3.5 - so if you are on Crowd Server as I am you might not get happy with it...

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you