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

[srinath]

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_]

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]

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