Forum Discussion

phoneboy's avatar
phoneboy
Director
3 years ago

Online User Count is Completely Wrong

I'm trying to get an accurate count of online users and it's quite obvious the count is completely wrong just by looking at the results I'm encountering on my staging environment. The LIQL query use...
Community API
REST API v2 & LiQL
SharathTP's avatar
SharathTP
Khoros Alumni (Retired)
3 years ago

Hi, 
The liql query

 

 

SELECT count(*) FROM users WHERE online_status='online'

 

 

 returns the count including the anonymous user sessions as well. 
The count returned should be matching the total count of members and guests online in the 'users online page'  

 

 

<community>/t5/forums/usersonlinepage

 

 

This can be checked to know whether the count returned by the liql is accurate. 

Coming to the part where the query 

 

 

SELECT login,last_visit_time FROM users WHERE online_status='online'

 

 

is returning the users who logged-in in 2021 etc.  We didn't observe this issue in our qa sites. In case you are still seeing any discrepancy, we request you to create a support ticket with the relevant details for further analysis.