Page MenuHomePhabricator

Find a way to quantify / get numbers for the work @aklapper is doing in Phabricator
Closed, ResolvedPublic

Description

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 "cli-xxxxx" transaction.search --

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"}' | /var/www/html/phab/arcanist/bin/arc call-conduit --conduit-uri https://phabricator.wikimedia.org/ --conduit-token "cli-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?

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 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)