Add On to capture user activity

[Scott Derderian]

Hi folks, we're looking to capture user activity in JIRA that goes beyond out-of-the-box Audit trail, or SQL Query 

What were looking to capture is not only when the last time a user has logged into the instance (easy enough to get via SQL Query) but to what extent they are using JIRA (i.e. actioning issues, creating boards, etc.). 

The end game here is to see what potential users we can inactivate in an effort to keep license counts under control.

Can anyone recommend an Add on or Plug in that we can utilize for this purpose?

We're running Jira Data Center on premises - version 8.5.3.

Please advise.  Thanks!

[Dibyandu Roy]

Currently there is no add-ons for this but it is possible to do this in sql by joining the tables. You need to spend time reading the tables from here and then create the sql query.

https://developer.atlassian.com/server/jira/platform/attachments/jira-7-9-2-database-schema.pdf

The above db schema file mentioned here:

https://developer.atlassian.com/server/jira/platform/database-schema/

If you are able to spend time to create it, do share to us.