How to find users' login history?

Question

Is it possible to find how many/which users logged into Jira during a particular time range? (by querying the database)

Renjith Pillai · Answer

May  be you can parse the access logs too.

cgauterio · Answer

HI MAK,

Yes, it is possible to do this. We have a page with some Example SQL queries for JIRA and there is one query that might help you achieve that. Please see:

List username, full name, email address, login count, and last time logged in

Hope it helps :)

Cheers,

Clarissa.