In Jira Every day login details

[Rajesh P]

Hi, I need to get it every day login detail names... Database postgres sql query.. Using the sql query i need to get by today login details.

Thanks

[Sreenivasaraju P]

Hi @Rajesh P ,

As per my knowledge all the login dates won't get stored in the database. 

Using database query , you can get only the last login time of the user, please refer below link for finding last login time of the user.

https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html

Each login or failure details are , logged in the atlassian-jira-security.log. You can refer this log, for the all the login details and failure login details.