login session report

Technical assistance
1

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.
2

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.