Change Details

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 [ ] Create task for next year --- 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

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` [x] Gather data [x] Send email - https://lists.wikimedia.org/hyperkitty/list/wikitech-l@lists.wikimedia.org/thread/WSGZKDVHS2B7S6JX3ERG3NBUSFXUAYGY/ [x] 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

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` [ x] Gather data [ ] Send emailx] Send email - https://lists.wikimedia.org/hyperkitty/list/wikitech-l@lists.wikimedia.org/thread/WSGZKDVHS2B7S6JX3ERG3NBUSFXUAYGY/ [ x] 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