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: