Previous tasks: T301181, T299400, T241781.
(Filing this task as individual non-public calendars are not a task tracking system.)
- Go to https://phabricator.wikimedia.org/conduit/method/project.query/ and query for phids = ["PHID-PROJ-koo4qqdng27q7r65x3cw"]
- Use the results in the members array to feed the phids into the SQL query: SELECT DISTINCT(CONCAT("https://phabricator.wikimedia.org/p/", userName)), isDisabled FROM phabricator_user.user WHERE phid NOT IN (SELECT trs.authorPHID FROM phabricator_maniphest.maniphest_transaction trs INNER JOIN phabricator_user.user u WHERE FROM_UNIXTIME(trs.dateModified) >= (NOW() - INTERVAL 1 YEAR) AND trs.authorPHID = u.phid) AND (phid = "PHID-USER-..." OR phid = "PHID-USER-...");
- Review the user names
- Once done, create a new task for the next review, and resolve this task.
Alternatively, for those with production DB access, another option is to run:
SELECT DISTINCT(CONCAT("https://phabricator.wikimedia.org/p/", usr.userName)), usr.isSystemAgent FROM phabricator_user.user usr WHERE usr.isDisabled = 0 AND usr.phid IN (SELECT e.src FROM phabricator_user.edge e WHERE e.dst = "PHID-PROJ-koo4qqdng27q7r65x3cw" AND e.type = 14 AND FROM_UNIXTIME(e.dateCreated) <= (NOW() - INTERVAL 12 MONTH)) AND usr.phid NOT IN (SELECT trs.authorPHID FROM phabricator_maniphest.maniphest_transaction trs INNER JOIN phabricator_user.user u WHERE FROM_UNIXTIME(trs.dateModified) >= (NOW() - INTERVAL 12 MONTH) AND trs.authorPHID = u.phid);