Hi,

These will be in metawiki's logging table. There's no sensible way to get it.

You need to look at the central auth logs on meta and then find the last entry referring to that account with the correct action.

On Wed, 30 Jun 2021 at 12:01, Pablo Aragón <paragon@wikimedia.org> wrote:
Hi!

I need to create a dataset of globally locked users and I have found them on MariaDB: select * from centralauth.globaluser where gu_locked=1.

Does anyone know where the lock timestamp and reason are stored?

Thanks in advance!


--
Pablo Aragón (he/him)
Research Scientist
Wikimedia Foundation
_______________________________________________
Analytics mailing list -- analytics@lists.wikimedia.org
To unsubscribe send an email to analytics-leave@lists.wikimedia.org
--
Thanks,
Samuel