Infos:
-
Used Zammad version: 6.3
-
Used Zammad installation type: docker-compose
-
Operating system: Windows
-
Browser + version: Any
-
Hello, i would like to get all current sessions and display it with grafana. We are using the postgres plugin and i connect to the DB. I can get the information like this:
“docker exec zammad-railsserver-1 /docker-entrypoint.sh rails r ‘p Sessions.list’”.
But i couldnt find any information of how the Session.list gets its information.
Users Table:
“id”,“organization_id”,“login”,“firstname”,“lastname”,“email”,“image”,“image_source”,“web”,“password”,“phone”,“fax”,“mobile”,“department”,“street”,“zip”,“city”,“country”,“address”,“vip”,“verified”,“active”,“note”,“last_login”,“source”,“login_failed”,“out_of_office”,“out_of_office_start_at”,“out_of_office_end_at”,“out_of_office_replacement_id”,“preferences”,“updated_by_id”,“created_by_id”,“created_at”,“updated_at”
Session Table:
“id”,“session_id”,“persistent”,“data”,“created_at”,“updated_at”
Anyone knows how the connect?
I can see the sessions in the UI