Find previously suspended users

(Joshua Rosenfeld) #1

Is it possible to get a list of users who were suspended at one time or another (not neccessarily actively suspended)?

(cpradio) #2

I think you can use this in the data explorer plugin

SELECT * FROM user_histories
  WHERE action = 10

I’m validating that 10 is suspended, but I believe it is.

And I found it is

(Joshua Rosenfeld) #3

OK, can it be done by a Moderator? To the best of my knowledge mods don’t have access to run queries.

(cpradio) #4

No, it can’t. But if you give it to your Admin, they can create the query, and you could use a master API key to access the queried data

(Joshua Rosenfeld) #5

Thanks @cpradio, this is less of an issue after I discovered that suspensions are logged…but no names are stored in logs. I would rather see a fix to that then need to bother the admins:

(system) #6

(Jeff Atwood) #7

Is that still the case @jomaxro?

(Joshua Rosenfeld) #8

I doubt it. That was 3 years ago, and the linked bug was fixed/closed. Will check to be sure.

(Joshua Rosenfeld) #10

Suspensions are definitely logged now, checked both /admin/logs/staff_action_logs and the downloaded CSV. Found a separate bug, but I’ll open a new topic for that.

(Joshua Rosenfeld) #11