Hello everyone,
Can someone please tell me where does Alfresco store data of users Login and Logout details. I want to get the time of a specific user that when did that user logged in and logged out.
If you enable the audit service you'll have this data (and a lot more unless you configure it to exclude what you don't need).
Go take a look at the audit service documentation to learn how to enable it, and then, once you do, try out the audit rest API to search the data.
Once you enable the audit service you can query the audit tables either via the audit REST API or by writing SQL against the database (these are the only tables you should ever query directly). Or you might consider extracting the data and putting it somewhere else that's a bit easier to query and that can scale without causing performance issues on your Alfresco db.
For example, at one of my clients I use an Apache Camel component to ingest audit records into Elasticsearch. That makes it easy to provide a nice front-end query tool that can report on login, logout, document create/read/update/delete, permission changes, and so on.
Hope that helps,
Jeff
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.