Re T297685, T270867, T240564. Needs Phab SQL access and a wikimedia.biterg.io account to create the Gerrit related short URLs.

2022-01-01T000000UTC = 1640995200
2023-01-01T000000UTC = 1672531200

• Gather data
• Send email - https://lists.wikimedia.org/hyperkitty/list/wikitech-l@lists.wikimedia.org/thread/WSGZKDVHS2B7S6JX3ERG3NBUSFXUAYGY/
• Create task for next year - T326562

Phabricator:

• How many tasks got created?
  • SELECT COUNT(tsk.dateCreated) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1640995199 AND tsk.dateCreated < 1672531200;
• How many tasks got closed?
  • SELECT COUNT(tsk.closedEpoch) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1640995199 AND tsk.closedEpoch < 1672531200;
• How many people were active in Phabricator?
  • SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM maniphest_transaction tsk WHERE tsk.dateCreated > 1640995199 AND tsk.dateCreated < 1672531200;
• How many people created tasks?
  • SELECT COUNT(DISTINCT (tsk.authorPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.dateCreated > 1640995199 AND tsk.dateCreated < 1672531200;
• Who created the most tasks?
  • SELECT usr.username, COUNT(usr.username) AS created FROM phabricator_user.user usr JOIN phabricator_maniphest.maniphest_task tsk WHERE tsk.authorPHID = usr.phid AND tsk.dateCreated > 1640995199 AND tsk.dateCreated < 1672531200 GROUP BY usr.username ORDER BY created DESC LIMIT 20;
• How many people closed tasks?
  • SELECT COUNT(DISTINCT (tsk.closerPHID)) FROM phabricator_maniphest.maniphest_task tsk WHERE tsk.closedEpoch > 1640995199 AND tsk.closedEpoch < 1672531200;
• Who closed the most tasks?
  • SELECT usr.username, COUNT(usr.username) AS closed FROM phabricator_user.user usr JOIN phabricator_maniphest.maniphest_task tsk WHERE tsk.closerPHID = usr.phid AND tsk.closedEpoch > 1640995199 AND tsk.closedEpoch < 1672531200 GROUP BY usr.username ORDER BY closed DESC LIMIT 20;

Gerrit:

• How many patchsets got created in Gerrit?
  • See "Gerrit 🡒 Changesets" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/8f0c69f9a6188d843f87afb1d4bd39ee
• How many reviews of patchsets happened in Gerrit?
  • See "Total Number of Code Reviews" on "Gerrit 🡒 Approvals": https://wikimedia.biterg.io/goto/074b7823a84be62de083a6ebbfa4d39a
• How many people created patchsets in Gerrit?
  • See "Gerrit 🡒 Changeset Submitters" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/8f0c69f9a6188d843f87afb1d4bd39ee
• Who created the most patchsets in Gerrit?
  • See "Submitters" on "Gerrit 🡒 Overview": https://wikimedia.biterg.io/goto/8f0c69f9a6188d843f87afb1d4bd39ee
• Who reviewed the most patchsets in Gerrit?
  • See "Approvals by Reviewer" on "Gerrit 🡒 Approvals": https://wikimedia.biterg.io/goto/074b7823a84be62de083a6ebbfa4d39a