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...
Forum Discussion
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.
All the /t5/forums/usersonlinepage tells me is what I learned from parsing the API results directly: there are named users marked "online" that I know for a fact are not.
And yes, I already have a support ticket open on this.
