Active users from Jira last 90days

[Vinay Shekars]

How can i get active users list from jira (v6.3.8) who are logged from last 90days.

Also who are not logged into Jira from last 90days.

Thanks

Vinay

[João Palharini]

Hi Vinay!

Luckily, I have been working with a colleague on a knowledge document indicating queries that retrieve from the database a list of users with the "Last Login" timestamp. You could use the queries there and do some adjustments to get only users that haven't logged in on the last 90 days.

As you can see, it lacks tests on other supported databases for JIRA 6.3+, like Oracle and Microsoft SQL Server, that's why the KB is still unfinished. If you use one of these databases, some adjustments to the queries' syntax should be performed.

Let me know if you have any doubts on this. I'll do my best to help out. 

--

Cheers!

Joao