...as proposed in T334628#8851175, for metrics part of https://www.mediawiki.org/wiki/Technical_Community_Newsletter
Description
Description
Details
Details
Related Changes in Gerrit:
Customize query in gerrit
Related Objects
Related Objects
- Mentioned In
- T372277: Fix timespan in links to Gerrit data on wikimedia.biterg.io in future Quarterly Newsletters
T370167: Update recipients list for quarterly Phabricator metrics
T362804: Automate quarterly WMF QLS request for Phabricator data (tasks reported by community, resolved by WMF)
T353242: Publish Quarterly Newsletter for January 2024
T334121: Gather Community metrics 2023 Q2 for Technical Community Newsletter in July 2023
T337388: Automate SQL queries for annual end-of-year Phabricator statistics/metrics on wikitech-l@
T338955: Make quarterly and yearly Phabricator statistics / metrics emails have a second recipient
T334628: Have a second person who can run Phabricator SQL queries to be provided for quarterly/yearly Phabricator statistics - Mentioned Here
- T334628: Have a second person who can run Phabricator SQL queries to be provided for quarterly/yearly Phabricator statistics
Event Timeline
Comment Actions
Change 922836 had a related patch set uploaded (by Aklapper; author: Aklapper):
[operations/puppet@production] Automate quarterly Phabricator metrics for Tech Community Newsletter
Comment Actions
Change 922836 merged by Dzahn:
[operations/puppet@production] Automate quarterly Phabricator metrics for Tech Community Newsletter
Comment Actions
Change 928943 had a related patch set uploaded (by Dzahn; author: Dzahn):
[operations/puppet@production] Revert "Revert "Automate quarterly Phabricator metrics for Tech Community Newsletter""
Comment Actions
Change 928943 merged by Dzahn:
[operations/puppet@production] Revert "Revert "Automate quarterly Phabricator metrics for Tech Community Newsletter""
Comment Actions
Change 929417 had a related patch set uploaded (by Dzahn; author: Dzahn):
[operations/puppet@production] phabricator: try to fix month range format for quartely timer
Comment Actions
Change 929417 merged by Dzahn:
[operations/puppet@production] phabricator: try to fix month range format for quartely timer
Comment Actions
Change 929423 had a related patch set uploaded (by Dzahn; author: Dzahn):
[operations/puppet@production] phabricator: replace cut with sed in quarterly_metrics.sh
Comment Actions
Change 929423 merged by Dzahn:
[operations/puppet@production] phabricator: replace cut with sed in quarterly_metrics.sh
Comment Actions
@Aklapper After follow-ups above, I think it's working :)
* [[mw:Phabricator|Phabricator]]: Number of tasks created in Q2/2023: 8098 * Phabricator: Number of tasks closed in Q2/2023: 7868 ...
See your inbox now.
Comment Actions
@Dzahn: Thanks a lot for fiddling with the systemd/cron parts! Resolving as the test email contains all expected data.
For verification of query syntax and data,
- ran manually SELECT COUNT(dateCreated) FROM phabricator_maniphest.maniphest_task WHERE dateCreated >= 1677628800; (that's the epoch for 2023-03-01T00:00:00UTC) and result is 8125.
- ran script's SELECT COUNT(dateCreated) FROM phabricator_maniphest.maniphest_task WHERE FROM_UNIXTIME(dateCreated,'%Y%m')>=DATE_FORMAT(NOW() - INTERVAL 3 MONTH,'%Y%m'); and result is also 8125.
As the script is triggered on the first of every three month, the results will be correct.
Reminder to myself: Create followup task so I'm not the only person receiving this because bus factor
Comment Actions
Confirming that this worked as expected on 1st July (and data was copied as expected)