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
SELECT hippolog:user,hippolog:timestamp FROM hippolog:item WHERE hippolog:timestamp >= 1740019200000 AND hippolog:timestamp <= 1740105599999 AND hippolog:action = ‘login’
Done