User Login Statistics via SugarCRM or Linux logs or MySql

[best_kobe_beef]

Hello,

i need to track down a case where maybe a user has logged in into my SugarCRM which should not (any more).

I use Sugar 5.5.0a and got full root-access to the corresponding linux server and the corresponding MySql Database behind the Sugar instance.

is there any chance to extract or grep a statistic of
1) which users logged on and when (datetime)
2) a complete history of user logins with all dates

I searched the log-file of SugarCRM (which is set to loglevel FAIL) and therefore only documents if a user typed in wrong credentials.

3) what do i need to enable to produce such data in the future?

Apache-Logs also were of no help for that matter. Maybe the MySql-Database behind Sugar has some record of user-logins?

Thanks in advance for any hints!

[best_kobe_beef]

resolved, used the tracker table in mysql which provided the requested information.