Thanks, Samuel! Your answer was as quick as it was valuable :)

On Wed, Jun 30, 2021 at 3:12 PM RhinosF1 - rhinosf1@gmail.com wrote:

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 https://research.wikimedia.org _______________________________________________ Analytics mailing list -- analytics@lists.wikimedia.org To unsubscribe send an email to analytics-leave@lists.wikimedia.org

-- Thanks, Samuel _______________________________________________ Analytics mailing list -- analytics@lists.wikimedia.org To unsubscribe send an email to analytics-leave@lists.wikimedia.org