Exclude banned users from total user count

[retiolus]

Requirements

• [X] Is this a feature request? For questions or discussions use https://lemmy.ml/c/lemmy_support
• [X] Did you check to see if this issue already exists?
• [X] Is this only a feature request? Do not put multiple feature requests in one issue.
• [ ] Is this a UI / front end issue? Use the lemmy-ui repo.

Is your proposal related to a problem?

And I'm not talking about the usernames, just the number.

With the wave of spambots we've had in recent days, my server (for example) has 181 users, 156 of whom have been banned. This would make it possible to have a "real" view of the number of users on each instance (even if the number of active users is too).

Describe the solution you'd like.

Add a way of getting the number of banned users on a server through the API, currently only an administrator account can obtain all the banned usernames.

Describe alternatives you've considered.

Do not count banned users in the number of users on the server.

Additional context

No response

[Nutomic]

Seems like the better solution would be not to include banned accounts in the user count.

[dessalines]

This needs new triggers on the person -> site_aggregates and community_aggregates on the banned column.