# login session report
**URL:** https://community.zammad.org/t/login-session-report/19220
**Category:** Technical assistance
**Created:** [December 8, 2025, 2:27pm UTC](https://community.zammad.org/t/login-session-report/19220 "2025-12-08T14:27:59Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@fagianijunior](https://community.zammad.org/u/fagianijunior)
#### Post date: [December 8, 2025, 2:27pm UTC](https://community.zammad.org/t/login-session-report/19220/1 "2025-12-08T14:27:59Z")
### Infos:
- Used Zammad version: 5.4.1
- Used Zammad installation type: Source on a AWS ECS environment
- Operating system: Linux
- Browser + version: Firefox 145.0.2 (64-bit)
### Expected behavior:
- I need to generate a report of login sessions from the past 3 months, including username, IP address, date, and time. I have access to the database and the Rails console, but I haven’t found an effective way to extract this data. What’s the best approach to generate this report?
### Actual behavior:
- Some SQL inconsistent data.
---
### Author:  [@MrGeneration](https://community.zammad.org/u/MrGeneration)
#### Post date: [December 8, 2025, 2:28pm UTC](https://community.zammad.org/t/login-session-report/19220/2 "2025-12-08T14:28:55Z")
> [@fagianijunior](#):
>
> - Used Zammad version: 5.4.1
Zammad 5.4.1 is _highly outdated_. The current stable is 6.4.2 which is also a security release. You might wanna patch and upgrade asap.
To the rest of your question: There is no convenient way to get the last logins. The best bet is Zammads log file, imho.