Would like to know who all users logged in to Jira and haven't updated anything in JIra from last 90

Question

Basically I am looking for following information

* Would like to know who all users haven’t logged in to Jira in Last 90 days
* And who all users logged in to Jira but I haven’t updated anything in Jira. ( updates on issues in any project

I am looking for SQL to pull these data from (oracle)database.

Amith Mathur {Appfire} · Answer

Hi @srinath reddy pinappu,

Natively, you cannot do so from the JIRA UI. But you will be able to get the results from the database, Please run the queries as mentioned here to get the data.

To check the users who haven't added any content, in JIRA, you can use the JQL or find the user workload report. (Project > report > user workload report) or you can use the activity stream for the same purpose.

Reference Link:

https://confluence.atlassian.com/jira064/user-workload-report-720416024.html?_ga=2.89802077.776718091.1549862501-230607409.1540785202

Thanks,
Amith Mathur

evzensx · Answer

Have a look at Atlassian KB: https://confluence.atlassian.com/jirakb/jira-accounts-not-used-in-the-last-90-days-695241569.html