# How is session and user connected?

**URL:** https://community.zammad.org/t/how-is-session-and-user-connected/14091
**Category:** Technical assistance
**Created:** [April 24, 2024, 7:52am UTC](https://community.zammad.org/t/how-is-session-and-user-connected/14091 "2024-04-24T07:52:20Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![SvenHerr](https://community.zammad.org/letter_avatar_proxy/v4/letter/s/8e7dd6/32.png) [@SvenHerr](https://community.zammad.org/u/SvenHerr)
#### Post date: [April 24, 2024, 7:52am UTC](https://community.zammad.org/t/how-is-session-and-user-connected/14091/1 "2024-04-24T07:52:20Z")

</div>

### 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

---

<div class="post-metadata">

### Author: ![system](https://community.zammad.org/uploads/default/original/1X/5c5afaea2d23f811dbec33cd4edb02fa29d3262f.png) [@system](https://community.zammad.org/u/system)
#### Post date: [April 19, 2025, 7:52am UTC](https://community.zammad.org/t/how-is-session-and-user-connected/14091/2 "2025-04-19T07:52:39Z")

</div>

This topic was automatically closed 360 days after the last reply. New replies are no longer allowed.
