# How to get user count & user session count using usql

**URL:** <https://community.dynatrace.com/t/how-to-get-user-count-user-session-count-using-usql/20832>\
**Category:** Real User Monitoring\
**Tags:** usql, user-sessions\
**Created:** [November 19, 2020, 2:40am UTC](https://community.dynatrace.com/t/how-to-get-user-count-user-session-count-using-usql/20832 "2020-11-19T02:40:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tarun\_kumar\_aga](https://avatars.discourse-cdn.com/v4/letter/t/c5a1d2/32.png) [@tarun\_kumar\_aga](https://community.dynatrace.com/u/tarun_kumar_aga)\
**Post date:** [November 19, 2020, 2:40am UTC](https://community.dynatrace.com/t/how-to-get-user-count-user-session-count-using-usql/20832/1 "2020-11-19T02:40:06Z")

</div>

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,

---

<div class="post-metadata">

**Author:** ![pahofmann](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pahofmann/32/17076_2.png) [@pahofmann](https://community.dynatrace.com/u/pahofmann)\
**Post date:** [November 19, 2020, 12:29pm UTC](https://community.dynatrace.com/t/how-to-get-user-count-user-session-count-using-usql/20832/2 "2020-11-19T12:29:13Z")

</div>

For the user session count you can use:

```auto
SELECT Count(*) FROM usersession

```

For user count use the following for tagged users:

```auto
SELECT Count(DISTINCT(userid)) FROM usersession

```

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

```auto
SELECT Count(DISTINCT(internalUserId)) FROM usersession

```