this post was submitted on 07 Jun 2023
2 points (100.0% liked)

Lemmy Support

4651 readers
1 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 6 years ago
MODERATORS
dessalines@lemmy.ml
2
User list? (links.dartboard.social)
submitted 2 years ago by knova@links.dartboard.social to c/lemmy_support@lemmy.ml
4 comments fedilink hide all child comments
 

Is there a way, as an admin, to see a list of users on my instance?

you are viewing a single comment's thread
view the rest of the comments
[–] ptz@lemmy.ptznetwork.org 2 points 2 years ago* (last edited 2 years ago)

To expand on that, I do a join between the local_user and person tables so I can grab the name and display names for the local users:

select 
  p.name, 
  p.display_name, 
  a.person_id, 
  a.email, 
  a.email_verified, 
  a.accepted_application 
from 
  local_user a, 
  person p 
where 
  a.person_id = p.id;