How to get user count & user session count using usql

tarun_kumar_aga — Mon, 26 Apr 2021 11:58:33 GMT

Hi,

I am trying to gather user count & user session count using usql,but the metrics it was giving is not matching.

Can someone help me with the proper query to get these metrics.

Thanks,

Re: How to get user count & user session count using usql

pahofmann — Thu, 19 Nov 2020 12:29:13 GMT

For the user session count you can use:

SELECT Count(*) FROM usersession

For user count use the following for tagged users:

SELECT Count(DISTINCT(userid)) FROM usersession

or this one if you want all users, including anonymous users:

SELECT Count(DISTINCT(internalUserId)) FROM usersession