How to find the number of users who all are using a particular plugin in Jira

[Mayoori Mohan]

How to find the number of users who all are using a particular plugin in Jira and how frequently they are using that plugin?

[Andy Heinzer]

Hi Mayoori,

I understand that you are looking to understand which users in Jira are utilizing a particular plugin.  This question is extremely difficult to answer because of the way that plugins work in Jira.   Essentially, for most plugins to Jira, there is not an easy way to determine this because of the current architecture of the plugin system in Jira. 

Plugins in Jira can perform lots of very different functions.  Many times these functions are global, meaning that all users are effecting using them, whether or not they know it.  In other cases, very few plugins will require users to be in specific groups in order to access them.  In those cases, it might be possible to measure this, but I think in general most plugins have not adopted this approach.   Given that the current plugin setup requires that plugins be licensed to the same level as the Jira user license, in most cases you have to license that plugin to the level that Jira is setup for.

There is a similar question about this from 2016 in https://community.atlassian.com/t5/Jira-questions/Jira-plugins-usage-statistics/qaq-p/409304 but I feel that the answer Nic has there is still accurate today.

Sorry there is likely not a clear answer for you here.  Is there a specific plugin that you are looking at here?  Perhaps we can offer a more concise answer if we understand what plugin you are using here.

Thanks

Andy

[Mayoori Mohan]

Hi Andy,

Thanks for the reply.

I am interested to know how many users or projects are using " Agile poker Plugin" in our instance.

Thanks

Mayoori

[Andy Heinzer]

Hi Mayoori,

Thanks for letting us know more about the use case here.  I don't have a full-proof way for you to determine this because of the way plugins like these are licensed in Jira.  In short, this plugin could potentially be used by any/all users in your environment.

That said, I did find that I could query the SQL database and at least bring back a list of user accounts that are involved in any current/active planning sessions.  For example, you could use a query such as:

SELECT par.*, au.lower_user_name
FROM "AO_62850F_PARTICIPANT" par
JOIN app_user au ON au.user_key=par."USER_KEY";

^ will return all the participants of a planning session

SELECT sm.*, au.lower_user_name
FROM "AO_62850F_SCRUM_MASTER" sm
JOIN app_user au ON au.user_key=sm."USER_KEY";

^ this one would return any scrum masters listed on any such plans.

But again I should note that both of these only helps you to identify users that currently have a agile poker session on going.  It won't help identify any users that might have recently used this plugin, but are not currently listed in any sessions.

I hope this helps.

Andy