# Hippo 12.6.8 users activity list

**URL:** <https://community.bloomreach.com/t/hippo-12-6-8-users-activity-list/4671>\
**Category:** Uncategorized\
**Created:** [February 24, 2025, 6:04am UTC](https://community.bloomreach.com/t/hippo-12-6-8-users-activity-list/4671 "2025-02-24T06:04:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![B\_A](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/b_a/32/1693_2.png) [@B\_A](https://community.bloomreach.com/u/B_A)\
**Post date:** [February 24, 2025, 6:04am UTC](https://community.bloomreach.com/t/hippo-12-6-8-users-activity-list/4671/1 "2025-02-24T06:04:39Z")

</div>

Good afternoon, my version of Hippo is 12.6.8, I would like to get the number of user authorizations? Or how many sessions does someone do? Information related to users. Please tell me how to do this

---

<div class="post-metadata">

**Author:** ![B\_A](https://yyz1.discourse-cdn.com/flex027/user_avatar/community.bloomreach.com/b_a/32/1693_2.png) [@B\_A](https://community.bloomreach.com/u/B_A)\
**Post date:** [February 24, 2025, 6:49am UTC](https://community.bloomreach.com/t/hippo-12-6-8-users-activity-list/4671/2 "2025-02-24T06:49:24Z")

</div>

SELECT hippolog:user,hippolog:timestamp FROM hippolog:item WHERE hippolog:timestamp \>= 1740019200000 AND hippolog:timestamp \<= 1740105599999 AND hippolog:action = ‘login’

Done