Page MenuHomePhabricator

Understand which Legalpad documents are still used
Closed, ResolvedPublic

Description

Run SELECT FROM_UNIXTIME(ls.dateCreated) AS signatureDate, u.userName, CONCAT("L",ld.id) AS doc FROM phabricator_legalpad.legalpad_documentsignature ls INNER JOIN phabricator_user.user u ON signerPHID = u.phid INNER JOIN phabricator_legalpad.legalpad_document ld ON ld.phid = ls.documentPHID ORDER BY ls.dateCreated DESC LIMIT 100; on phab1004.

Cannot do myself b/c https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+/refs/heads/production/modules/profile/templates/mariadb/grants/production-m3.sql.erb but may try to sudo my way.

Event Timeline

Aklapper triaged this task as Low priority.
Aklapper claimed this task.

80 signatures added within the last 3 months, part of them likely spam accounts. I'll post some results in the parent task.