[Analytics] Re: About globally locked users

2021-06-30 Thread Pablo Aragón
Thanks, Samuel! Your answer was as quick as it was valuable :) On Wed, Jun 30, 2021 at 3:12 PM RhinosF1 - 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 referrin

[Analytics] Re: About globally locked users

2021-06-30 Thread RhinosF1 -
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 wrote: > Hi! > > I need to create a dat

[Analytics] About globally locked users

2021-06-30 Thread Pablo Aragón
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 Found