Login User details for Last 24 Hours, 7days, 1 Month, 6 Months and 1 Year in JIRA Server.

[PRAMOD KUMAR REDDY KASIREDDY]

We aim to migrate our Jira server instance, which currently has over 4500 active users, hence we require information like recently logged users.

1) Count of user login's  withing 24 Hours.

2) Count of user login's  withing Last 7 Days.

3) Count of user login's  withing One month, Six Moths and Year.

[Aditya Verma]

Hi @PRAMOD KUMAR REDDY KASIREDDY ,

Are you targeting to disable users who have not logged in for a long time ?Then getting the list of uses who have not logged in for certain days would give you a better idea.

Queries on this link will give you list of users who have not logged in for 90 days . You can select a query based on your database and replace the time duration as per your requirement in the sql query.

Thanks,

Aditya