Hi Srijan, I don't know of any place you can get this information immediately. You can use couple of tables to get the information you need (more accurately). You can use centralauth.globaluser to get the gu_id (global user id), gu_registration, and gu_home_db. You can then use enwiki.user_daily_contribs to find which one of those users have done at least one edit after registration. You don't need to look too far after the registration date for the first edit activity. If someone has opened an account and has done no edit in the first 7 days (I look at 2 days for rough estimations), you can safely assume that the account won't have edits. If you compute this number, please update this thread so we know what the answer is. Thanks! :-) Leila On Sun, Aug 2, 2015 at 1:25 PM, Srijan Kumar <srijankedia(a)gmail.com> wrote: _______________________________________________ Wiki-research-l mailing list Wiki-research-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wiki-research-l