Commons:Database reports
Shortcut
COM:DBR
COM:DBR
This page serves as an index of database reports generated from replicated databases. Many of these lists show possible problems with various areas of the wiki which may need fixing.
Current reports[edit]
| Report | Run frequency | Data as of |
|---|---|---|
| Blocks | ||
| Indefinitely blocked IPs | Weekly | 12:01, 22 May 2018 (UTC) Edit by BernsteinBot
|
| Locked users in local usergroup | Daily | 04:00, 27 May 2018 (UTC) |
| Range blocks | Weekly | 12:05, 22 May 2018 (UTC) Edit by BernsteinBot
|
| Unusually long IP blocks | Monthly | 12:01, 08 May 2018 (UTC) Edit by BernsteinBot
|
| Unusually long user blocks | Monthly | 12:05, 08 May 2018 (UTC) Edit by BernsteinBot
|
| Copyright-related blocks | Daily | 12:01, 27 May 2018 (UTC) |
| Block which will expire in the next three days | Daily | 12:01, 27 May 2018 (UTC) |
| Previously blocked ip's | Daily | 12:08, 27 May 2018 (UTC) |
| Categories | ||
| Unbelievable life spans | Weekly | 01:06, 18 January 2015 (UTC) |
| Self-categorized categories | Weekly | 06:15, 23 May 2018 (UTC) Edit by BernsteinBot
|
| Categories on Commons containing the most videos | ||
| Files | ||
| File description pages containing no templates | Weekly | 05:14, 18 January 2015 (UTC) |
| File description pages without an associated file | Weekly | 05:14, 18 January 2015 (UTC) |
| Largely duplicative file names | Daily | 05:43, 14 August 2017 (UTC) Edit by BernsteinBot
|
| High risk images used in English Wikipedia biographies overwritten in the last week | Hourly | 11:11, 27 May 2018 (UTC) |
| Upload log stats | Daily | 04:17, 27 May 2018 (UTC) |
| Previously deleted files | Daily | 06:36, 13 May 2017 (UTC) |
| Recently overwritten files | Daily | 12:01, 27 May 2018 (UTC) |
| Mistagged non-free files | Daily | 04:07, 27 May 2018 (UTC) |
| Files with incorrect extensions | Weekly | 02:25, 20 May 2018 (UTC) |
| Files with multiple extensions | Monthly | 01:49, 01 May 2018 (UTC) |
| GIF metadata validity check | Manual | 07:40, 26 September 2017 (UTC) |
| Video and audio uploads (watcher) | Daily | 03:01, 27 May 2018 (UTC) |
| Getty Images | Daily | 12:25, 27 May 2018 (UTC) |
| Most globally used videos from commons | ||
| Resolution upgrade needed | Daily | 03:32, 27 May 2018 (UTC) |
| Pages | ||
| Blank single-author pages | Daily | 12:01, 27 May 2018 (UTC) |
| Long pages | Weekly | 06:55, 18 January 2015 (UTC) |
| Orphaned talk pages | Semi-weekly | 06:58, 18 January 2015 (UTC) |
| Short single-author pages | Daily | 07:41, 25 January 2015 (UTC) |
| Redirects | ||
| Redirects containing red links | Weekly | 07:21, 18 January 2015 (UTC) |
| Users | ||
| Users active in last 30 days with 10,000 edits and those recently inactive | Daily | 04:44, 27 May 2018 (UTC) |
| Noticeboard stats | Daily | 12:01, 27 May 2018 (UTC) |
| Blank user talk pages for IPs | Weekly | 05:31, 19 January 2015 (UTC) |
| Blocked users in user groups | Semimonthly | 03:00, 20 May 2018 (UTC) Edit by BernsteinBot
|
| Inactive users in user groups | Semimonthly | 05:31, 19 January 2015 (UTC) |
| Miscellaneous | ||
| Page count by namespace | Daily | 05:24, 19 January 2015 (UTC) |
| Pages with the most revisions | Monthly | 02:44, 29 November 2015 (UTC) |
| User preferences | Daily | 02:00, 27 May 2018 (UTC) |
| Statistic of edits in the MediaWiki namespace | Daily | 02:01, 27 May 2018 (UTC) |
| Users by log action | Daily | 12:19, 27 May 2018 (UTC) |
| Users by log action (Translation) | Daily | 12:02, 27 May 2018 (UTC) |
| Meta categories count by suffix | Daily | 03:21, 09 February 2018 (UTC) |
| Abuse filter effectiveness | Daily | 05:44, 19 December 2017 (UTC) |
| OTRS permission filter watcher | Daily | 12:01, 27 May 2018 (UTC) |
An index of disabled reports is available here.
MediaWiki reports[edit]
Some database reports are generated by the MediaWiki software directly (not using the replicated databases at toollabs).
Requests[edit]
Please list any requests for reports on the talk page or on m:Tech. Be as specific as possible, including how often you would like the report run.
