On Fri, Feb 13, 2015 at 2:25 AM, Pedro <[email protected]> wrote: > Robinson Tryon wrote >> 17,892 total user accounts in Bugzilla, comprising >> 536 users who have successfully migrated from FDO, >> 17,002 who haven't, and >> 354 new accounts. > > So, in total 890 registered users (pretty good!) > > > Robinson Tryon wrote >> In terms of activity, we've had >> 448 users active in the last week, and >> 1304 active in the last month. > > More active users than registered???
It's a Bugzilla miracle! :P Hmm.. not sure what the database is telling us. I'm looking at the dates of activity in the profiles and profiles_activity tables in Bugzilla. In the later table, I had to use the 'distinct' clause to try to pull-out unique individuals, and it's possible that I'm underestimating (?) the total number of people in some cases. All the queries I used I put here. Any Postgres/Bugzila wizards have some suggestions? :-) https://wiki.documentfoundation.org/QA/Bugzilla/Administration#User_Statistics Best, --R -- Robinson Tryon QA Engineer - The Document Foundation LibreOffice Community Outreach Herald [email protected] _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: [email protected] Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
