# Show how many total users my forum has

**URL:** https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621
**Category:** Support
**Created:** [17.Октябрь.2016 01:16:08 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621 "2016-10-17T01:16:08Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![dandv](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dandv/32/169779_2.png) [@dandv](https://meta.discourse.org/u/dandv)
#### Post date: [17.Октябрь.2016 01:16:08 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/1 "2016-10-17T01:16:08Z")

</div>

Is there a way to easily _share_ this statistic with others, e.g. a public URL similar to the stats that MyBB has?

I couldn’t find the total number of users on the Dashboard page, aside from manually summing up the Users per Trust Level. The Users tab doesn’t show any statistics.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [17.Октябрь.2016 01:17:51 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/2 "2016-10-17T01:17:51Z")

</div>

`/about` has it on it, we should probably just change `New Users` to `Users` on that page cause `new` all time is just confusing.

---

<div class="post-metadata">

### Author: ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [17.Октябрь.2016 02:50:10 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/3 "2016-10-17T02:50:10Z")

</div>

I usually use the count on the /users page

Here  
/users 22051 users  
/about 22.0k

On my localhost set-up I have some discrepancies.  
I know I created 54 accounts. (in addition to system and eviltrout that I didn’t create)  
Running `SELECT MAX(id) FROM users` gives 54  
But my /users shows 51  
my /about shows 45  
my dashboard per TL adds up to 45  
and my dashboard new users all shows 45

I have 3 suspended and 2 blocked users, 1 account never authenticated and 2 never made a post (but 1 has Liked) and 1 has posted only in PMs.

AFAICT anonymous accounts aren’t in any count.

So it looks like /users counts members that have posted in public topics regardless of member status while elsewhere certain accounts aren’t included in the tally.

Or it could just be localhost install funkiness.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [20.Январь.2017 01:08:20 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/4 "2017-01-20T01:08:20Z")

</div>

> [@sam](#):
>
> /about has it on it, we should probably just change New Users to Users on that page cause new all time is just confusing.

OK, I agree and made that change.

---

<div class="post-metadata">

### Author: ![dax](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dax/32/244677_2.png) [@dax](https://meta.discourse.org/u/dax)
#### Post date: [29.Январь.2017 10:17:19 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/5 "2017-01-29T10:17:19Z")

</div>

> [@Mittineague](#):
>
> I usually use the count on the /users page
> 
> Here /users 22051 users /about 22.0k

This count also automatically keeps track of deleted users by @system?

---

<div class="post-metadata">

### Author: ![Mittineague](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/mittineague/32/114259_2.png) [@Mittineague](https://meta.discourse.org/u/Mittineague)
#### Post date: [29.Январь.2017 20:08:44 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/6 "2017-01-29T20:08:44Z")

</div>

> [@Trash](#):
>
> This count also automatically keeps track of deleted users by @system?

As far as I have been able to figure out, the only place there is record of system deleted accounts is in the `user_histories` table, although a `MAX(id)` ~ `COUNT(id)` comparison of the `users` table should give at least an approximate idea of how many accounts have been deleted. The deleted accounts are not included in either /users or /about

On my localhost “production” install /users has a count of 57 members and /about a count of 50

It appears that the difference is not due to deleted accounts, but due to “anonymous mode” accounts. That is, while I was testing the anonymous mode feature, 7 members tried it and 7 anonymous member accounts were created.

Whether or not they count as real members depends on how you look at it I guess.

---

<div class="post-metadata">

### Author: ![dax](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dax/32/244677_2.png) [@dax](https://meta.discourse.org/u/dax)
#### Post date: [30.Январь.2017 23:19:44 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/7 "2017-01-30T23:19:44Z")

</div>

> [@Mittineague](#):
>
> As far as I have been able to figure out, the only place there is record of system deleted accounts is in the user\_histories table, although a MAX(id) ~ COUNT(id) comparison of the users table should give at least an approximate idea of how many accounts have been deleted. The deleted accounts are not included in either /users or /about

Interesting. To do that I image you can also use [Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin and create a query to display how many users has been deleted in a time frame.

Don’t you think it’s better if this specific data is displayed by default on the `dashboard`?  
Especially for new or particular communities, so that administrators can realize how many people “abandon” their site and take some measure (better thread or support or anything else).

It’s not my particular case (my forum is mainly a support forum) but I think most of the site need something similar to figure out if the forum or site is “growing well”.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [27.Апрель.2019 01:38:27 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/8 "2019-04-27T01:38:27Z")

</div>



---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [29.Апрель.2019 01:00:02 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/9 "2019-04-29T01:00:02Z")

</div>

Site stats have been heavily simplified over the years in `/about`

 ![image](https://global.discourse-cdn.com/meta/original/3X/6/b/6b90f4d31e3c12753c57bd58cbca2e26aa02b398.png)

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [29.Май.2019 01:10:09 UTC](https://meta.discourse.org/t/show-how-many-total-users-my-forum-has/51621/10 "2019-05-29T01:10:09Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
