I need to generate a report (html, json, any output) that informs users' data (users and person) of the status and what the last login of this user was (last time he logged in). Is there any query or console that reports this data? I do not want to generate (at this time) any audit (additional log) or use Alflytics.
I am using alfresco 5.2 with the default Postgresql database.
There is no out-of-the-box reliable way to get such details. This already starts with the fact that there is no recording of such information anywhere in the system. This specifically was one of the reasons that I had to develop a custom audit addon for a customer once, because they wanted to regularly deauthorise users who haven't been active for a specific amount of time.