[MediaWiki-l] Reporting tool?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[MediaWiki-l] Reporting tool?

Gregory Rundlett
I'd like to be able to report on the activity (contributions) of a group of
editors.  I simply want to know how many edits ea. made on a month by month
basis.  Is there any tool that would offer such functionality?  It's labor
intensive to view ea. user's contributions and compile the data manually.

Thanks,

Greg

Greg Rundlett
*principal consultant*
eQuality Technology

*Let's work together*

https://equality-tech.com
follow us: https://twitter.com/eQualityTech
*creators of QualityBox <https://QualityBox.us>*
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Reply | Threaded
Open this post in threaded view
|

Re: Reporting tool?

Brian Wolff
If you're just looking for the last month, Special:ActiveUsers is probably
a lot more convenient than looking at contribs. $wgEdititis = true can also
add counters to some place

Edit counters for wikimedia wikis are common on toolforge, but most of
those aren't exactly the most portable.

This is the sort of report stats though that are really easy to generate
with SQL. e.g. to get monthly edits of all admins:

select rev_user_text 'user', concat( substr( rev_timestamp, 1, 4 ), "-",
substr( rev_timestamp, 5, 2 ) ) 'YYYY-MM', count(*) 'edits' from revision
inner join user on rev_user = user_id inner join user_groups on ug_user =
user_id and ug_group = 'sysop' group by 1,2 ;

[Note that the db structure changed in 1.33, after that you would instead
do]:

select user_name 'user', concat( substr( rev_timestamp, 1, 4 ), "-",
substr( rev_timestamp, 5, 2 ) ) 'YYYY-MM', count(*) 'edits' from revision
inner join actor on rev_actor = actor_id inner join user on actor_user =
user_id inner join user_groups on ug_user = user_id and ug_group = 'sysop'
group by 1,2;

--
Brian

On Tue, Sep 10, 2019 at 7:58 AM Gregory Rundlett <[hidden email]>
wrote:

> I'd like to be able to report on the activity (contributions) of a group of
> editors.  I simply want to know how many edits ea. made on a month by month
> basis.  Is there any tool that would offer such functionality?  It's labor
> intensive to view ea. user's contributions and compile the data manually.
>
> Thanks,
>
> Greg
>
> Greg Rundlett
> *principal consultant*
> eQuality Technology
>
> *Let's work together*
>
> https://equality-tech.com
> follow us: https://twitter.com/eQualityTech
> *creators of QualityBox <https://QualityBox.us>*
> _______________________________________________
> MediaWiki-l mailing list
> To unsubscribe, go to:
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l