- Mentioned In
- T197629: Andre to provide email addresses of new developers who were last active in July-September 2017
- Mentioned Here
- T185316: "Authors With No Activity During Last 6 Months" on C_Gerrit_Demo lists some users who have been active in the last 6 months
T176483: Conduct a first survey targeting volunteers who left after a few contributions
Index got updated by Jesus in https://gitlab.com/Bitergia/c/Wikimedia/support/issues/17#note_60596726 when working on T185316 hence I could proceed.
- https://wikimedia.biterg.io/app/kibana#/dashboard/C_Gerrit_Demo lists 56 entries for 04/2017 to 06/2017, with "Independent" affiliation filter applied.
- Create SQL query to get email addresses: SELECT DISTINCT name,email FROM identities WHERE source = "gerrit" AND (name="ABC" OR name="XYZ");
- Get 59 entries (some users have more than one email address registered)
- Remove 3 duplicates by checking for their latest address used on gerrit.wikimedia.org
- Passed the 56 email addresses to Srishti.
Closing as resolved.