[04:21:10] hey tgr [04:21:17] I know you can't see this now probably [04:21:27] but the analytics-store has all dbs in one db server so you can query them all in one go [04:23:39] YuviPanda: I was hoping for something like a huge table with all the users [04:23:57] that aren't in centralauth? [04:23:59] the warehouse has one but it looks like it's mostly empty [04:24:12] all the local users [04:24:20] ah, right. I don't think they have that yet. [04:24:27] but my info might be outdated by a few months [04:24:34] in the end I just foreachwikied through all DBs [04:24:36] you are unlikely to find them saturday nigt though [04:24:38] ah [04:24:40] cool [04:24:42] that works too :D [14:55:54] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: Backlogs of open changesets by affiliation - https://phabricator.wikimedia.org/T113719#1984880 (Aklapper) [14:58:24] Analytics-Tech-community-metrics, DevRel-January-2016: demographics.html: "Tickets participants" has "184 attracted" data for 1yearLowest [14:58:47] Analytics-Tech-community-metrics, pywikibot-core, DevRel-February-2016, DevRel-January-2016, Upstream: Statistics for SCM project 'core' mix pywikibot/core, mediawiki/core and oojs/core - https://phabricator.wikimedia.org/T123808#1984885 (Aklapper) [14:58:49] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: demographics.html: "Tickets participants" has "184 attracted" data for 1year Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: Make GrimoireLib display *one* consistent name for one user, plus the *current* affiliation of a user - https://phabricator.wikimedia.org/T118169#1984888 (Aklapper) [14:58:55] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: Many profiles on profile.html do not display identity's name though data is available - https://phabricator.wikimedia.org/T117871#1984889 (Aklapper) [14:58:57] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: Empty "subject" and "creator" fields for mailing list thread on mls.html - https://phabricator.wikimedia.org/T116284#1984890 (Aklapper) [14:58:59] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: "Tickets" (defunct Bugzilla) vs "Maniphest" sections on korma are confusing - https://phabricator.wikimedia.org/T106037#1984892 (Aklapper) [14:59:01] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: Affiliations and country of resident should be visible in Korma's user profiles - https://phabricator.wikimedia.org/T112528#1984891 (Aklapper) [14:59:03] Analytics-Tech-community-metrics, DevRel-February-2016, DevRel-January-2016: Contributor pages which show user name but not any other data should include an explanation - https://phabricator.wikimedia.org/T58111#1984893 (Aklapper) [22:50:40] Analytics: Pageview API should filter artificial traffic - https://phabricator.wikimedia.org/T125361#1985359 (Slaporte) NEW