Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need to query last 90 days data in Jira

Abhilasha Seth
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 16, 2021

Is there a way/API to find the last login timestamp of users who haven't logged into Jira in the last 90 days without querying the database. 

2 answers

0 votes
Mehmet A _Bloompeak_
Atlassian Partner
September 16, 2021

Hi @Abhilasha Seth ,

In the past, as part of quarterly user recertification process, we were manually checking last activity dates on Jira and Confluence and deactivating inactive users one by one. To make this process more straightforward, we developed Manage User for Jira app. You can search users, sort them by name, by active status, by last activity date and deactivate/activate users individually or in bulk. Hope it helps.

manage-users-for-jira-1280x800.jpg

0 votes
Alex Koxaras -Relational-
Community Champion
September 16, 2021

Hi @Abhilasha Seth and welcome to the community!

If you are a site admin, you can go to the cog and then user management. Then select USERS from the left menu (if not selected automatically). Then choose to export all the users with product membership.

You'll get a csv file, which you can modify to your liking and see for every user when was the last time he/she was active on each product.

export.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events