Page MenuHomePhabricator

Quantify / get numbers for the work @aklapper is doing in Phabricator
Closed, ResolvedPublic

Description

Not working: Was thinking about https://phabricator.wikimedia.org/conduit/method/transaction.search/ but that does not work as it always requires an objectIdentifier (like a task ID)?! Need to re-read https://secure.phabricator.com/T13255#244631 ... echo '{"constraints":[{"authorPHIDs":["PHID-USER-hgn5uw2jafgjgfvxibhh"]}], "after":"someEpochValue"}' | /var/www/html/phab/arcanist/bin/arc call-conduit --conduit-uri https://phabricator.wikimedia.org/ --conduit-token "api-xxxxx" transaction.search --

Not working: Was then thinking about custom https://phabricator.wikimedia.org/conduit/method/user.transactions/ added in D1144 but that does not provide any paging? Meh.

So fiddling with offset and comparing the dateCreated with the epoch value for 20190701H0000 being 1561939200, I see that my first transaction on 2019-07-01 was offset 90247. And that so far my last one was offset 94734. (Means 4488 transactions so far for this quarter):
echo '{"username":"aklapper", "offset":"123456789"}' | /var/www/html/phab/arcanist/bin/arc call-conduit --conduit-uri https://phabricator.wikimedia.org/ --conduit-token "api-xxxxx" user.transactions --

So I guess

  • I want to be able to pass an epoch value to user.transactions (maybe possible and I'm too stupid?) and
  • I want some paging to iterate through the results.

Not working: For the records, cannot use https://wikimedia.biterg.io/ for this as they don't index all and any actions - see T161928: Maniphest Backend: Consider having metrics covering *any* user activity in Maniphest

Event Timeline

Aklapper triaged this task as Lowest priority.Sep 20 2019, 2:55 PM
Aklapper created this task.

96786 is the offset for Oct1st. = 6539 interactions in Q3/2019.

Aklapper closed this task as Resolved.EditedDec 13 2019, 12:11 PM

Also documented that on my internal WMF Continuity page:

  • XX tickets about Phab and project tags resolved: Search in Phab via assignee and set "Closed after" and "Closed before" fields
  • XX comments on Phab Help talk page: Go count!
  • Removed inactive or deactivated assignees from XX open tasks: Search local bugmail for Subject contains "[Maniphest] [Unassigned]" && Sender contains "aklapper" && Date received is after 3 months ago
  • Archived XX projects: Search local bugmail for Subject contains "[Project] [Updated]" && Sender contains "aklapper" && Message body contains "Aklapper archived this project" && Date received is after 3 months ago
  • XXXX transactions (comments, cleanup etc) by Andre in total: Run echo '{"username":"aklapper", "offset":"101180"}' | /var/www/html/phab/arcanist/bin/arc call-conduit --conduit-uri https://phabricator.wikimedia.org/ --conduit-token "api-xxxxxxxxxxxxxxxxx" user.transactions -- to get the ID of the last transaction (and its date), then do the math by subtracting the transaction number from three months ago (2019-10-01 was 96786)
  • Any potential qualitative PM work helping maintainers, stewards, teams to organize their work in Phabricator

2019-Q4:

  • 47 assigned tickets resolved
  • 7 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 106 open tasks
  • Archived 25 Phabricator project tags
  • 5377 transactions (comments, cleanup etc) by Andre in total (2020-01-01 was 102163, 2019-10-01 was 96786)

2020-Q1:

  • 32 assigned tickets resolved
  • 16 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 148 open tasks
  • Archived 32 Phabricator project tags
  • 5324 transactions (comments, cleanup etc) by Andre in total (2020-04-01 was 107487, 2020-01-01 was 102163)
Aklapper renamed this task from Find a good way to get numbers how much work @aklapper is doing in Phabricator to Find a way to quantify / get numbers for the work @aklapper is doing in Phabricator.Apr 10 2020, 11:58 AM

2020-Q2:

  • 59 assigned tickets resolved
  • 25 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 691 open tasks
  • Archived 45 Phabricator project tags
  • 10434 transactions (comments, cleanup etc) by Andre in total (2020-07-01 was 117921, 2020-04-01 was 107487)

2020-Q3:

  • 38 assigned tickets resolved
  • 26 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 4 open tasks
  • Archived 21 Phabricator project tags
  • 4432 transactions (comments, cleanup etc) by Andre in total (2020-10-01 was 122353, 2020-07-01 was 117921)

2020-Q4:

  • 41 assigned tickets resolved
  • 21 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 320 open tasks
  • Archived 26 Phabricator project tags
  • 10645 transactions (comments, cleanup etc) by Andre in total (2021-01-01 was 132998, 2020-10-01 was 122353)

2021-Q1:

  • 37 assigned tickets resolved
  • 30 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 20 open tasks
  • Archived 35 Phabricator project tags
  • 4430 transactions (comments, cleanup etc) by Andre in total (2021-01-01 was 132998, 2020-04-01 was 137428)

2021-Q2:

  • 45 assigned tickets resolved
  • 34 comments on the Phab Help talk page
  • Removed inactive or deactivated assignees from 168 open tasks
  • Archived 25 Phabricator project tags
  • 7330 transactions (comments, cleanup etc) by Andre in total (2021-04-01 was 137428, 2020-07-01 was 144758)

2021-Q3:

  • 38 assigned tickets resolved
  • 23 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 38 open tasks
  • Archived 14 Phabricator project tags
  • 4042 transactions (comments, cleanup etc) by Andre in total (2021-07-01 was 144758, 2020-10-01 was 148800)

2021-Q4:

  • 33 assigned tickets resolved
  • 21 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 30 open tasks
  • Archived 10 Phabricator project tags
  • 2831 transactions (comments, cleanup etc) by Andre in total (2021-10-01 was 148800, 2022-01-01 was 151631)

2022-Q1:

  • 39 assigned tickets resolved
  • 42 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 402 open tasks
  • Archived 41 Phabricator project tags
  • 10039 transactions (comments, cleanup etc) by Andre in total (2022-01-01 was 151631, 2022-04-01 was 161670)

2022-Q2:

  • 83 assigned tickets resolved
  • 23 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 43 open tasks
  • Archived 6 Phabricator project tags
  • 3395 transactions (comments, cleanup etc) by Andre in total (2022-04-01 was 161670, 2022-07-01 was 165065)
Aklapper renamed this task from Find a way to quantify / get numbers for the work @aklapper is doing in Phabricator to Quantify / get numbers for the work @aklapper is doing in Phabricator.Sep 30 2022, 2:04 PM

2022-Q3:

  • 62 assigned tickets resolved
  • 19 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 376 open tasks
  • Archived 16 Phabricator project tags
  • 4745 transactions (comments, cleanup etc) by Andre in total (2022-07-01 was 165065, 2022-10-01 was 169810)

2022-Q4:

  • 38 assigned tickets resolved
  • 15 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 23 open tasks
  • Archived 62 Phabricator project tags
  • xxxx transactions (comments, cleanup etc) by Andre in total (2022-10-01 was 169810, 2023-01-01 was 172877)

2023-Q1:

  • 44 assigned tickets resolved
  • 21 comments on Phab Help talk page
  • Removed inactive or deactivated assignees from 247 open tasks
  • Archived 17 Phabricator project tags
  • 4532 transactions (comments, cleanup etc) by Andre in total (2023-01-01 was 172877, 2023-04-01 was 177409)