We are using Atlassian/JIRA Server and we need a report showing all users and when they logged in last. How do we accomplish that?
The easiest thing is to go to the "User management" section of the administration interface and look at the "Login Details" column. If you want to present the data outside of Jira, you can change the "Users per page" to "All" and then copy the table of users and paste to your favorite spreadsheet program. It's also possible to pull the data straight out of the database using a simple SQL string, but that requires a bit of familiarity with databases. I hope that helps
You can check this link:
https://confluence.atlassian.com/jirakb/retrieve-last-login-dates-for-users-from-the-database-363364638.html
It looks like you're new here. Sign in or register to get started.
![Photo of Dave Theodore [Coyote Creek Consulting]](https://us.v-cdn.net/6038660/uploads/avatars/be/ad/nbead3954437e7065e4d119624fd7f5e3.png)
