Commons:Database reports
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 | 05:25, 25 April 2025 (UTC) Edit by MDanielsBot
|
| Locked users in local usergroup | Daily | 04:01, 06 October 2020 (UTC) |
| Range blocks | Weekly | 05:25, 25 April 2025 (UTC) Edit by MDanielsBot
|
| Unusually long IP blocks | Weekly | 05:25, 25 April 2025 (UTC) Edit by MDanielsBot
|
| Unusually long user blocks | Weekly | 05:25, 25 April 2025 (UTC) Edit by MDanielsBot
|
| Copyright-related blocks | Daily | 10:06, 24 April 2025 (UTC) |
| Block which will expire in the next three days | Daily | 05:51, 24 April 2025 (UTC) |
| Previously blocked ip's | Daily | 06:41, 24 April 2025 (UTC) |
| Categories | ||
| Unbelievable life spans | Weekly | 01:06, 18 January 2015 (UTC) |
| Self-categorized categories | 02:24, 17 February 2025 (UTC) Edit by MDanielsBot
| |
| Self-categorized categories | 09:11, 20 October 2024 (UTC) | |
| Uncategorized categories | 07:19, 01 February 2025 (UTC) Edit by Wikiwerner
| |
| Uncategorized categories with infobox | 10:13, 04 December 2024 (UTC) | |
| Uncategorized categories with redcategories | 07:01, 02 February 2025 (UTC) Edit by Wikiwerner
| |
| Uncategorized categories with only infobox categories | 05:34, 23 April 2025 (UTC) Edit by MDanielsBot
| |
| Uncategorized categories with redcategories that are empty | 02:53, 26 October 2024 (UTC) | |
| Categories on Commons containing the most videos | ||
| Files | ||
| File description pages containing no templates | Weekly | 06:56, 28 December 2024 (UTC) Edit by Mdaniels5757
|
| File description pages without an associated file | occasionally (test run) | 07:00, 22 April 2025 (UTC) |
| Files without an associated file description page | occasionally (test run) | 08:05, 22 April 2025 (UTC) |
| Largely duplicative file names | Daily | 03:36, 10 October 2022 (UTC) Edit by BernsteinBot
|
| High risk images used in English Wikipedia biographies overwritten in the last week | Hourly | 02:30, 16 April 2019 (UTC) |
| Upload log stats | Daily | 09:58, 24 April 2025 (UTC) |
| Previously deleted files | Daily | 05:35, 25 April 2025 (UTC) |
| Recently overwritten files | Daily | 04:14, 24 April 2025 (UTC) |
| Mistagged non-free files | Daily | 04:03, 03 May 2021 (UTC) |
| Files with incorrect extensions | Weekly | 06:33, 28 December 2021 (UTC) Edit by Leonel Sohns
|
| Files with multiple extensions | Monthly | 04:08, 15 January 2023 (UTC) |
| GIF metadata validity check | Manual | 12:09, 04 September 2018 (UTC) |
| Video and audio uploads (watcher) | Daily | 11:07, 24 April 2025 (UTC) |
| Getty Images | Daily | 12:09, 25 April 2025 (UTC) |
| Most globally used videos from commons | ||
| Resolution upgrade needed | Daily | 05:02, 14 December 2024 (UTC) |
| Pages | ||
| Blank single-author pages | Daily | 05:25, 25 April 2025 (UTC) Edit by MDanielsBot
|
| Long pages | Weekly | 02:27, 18 March 2021 (UTC) |
| Orphaned talk pages | Semi-weekly | 06:58, 18 January 2015 (UTC) |
| Short single-author pages | Daily | 07:41, 25 January 2015 (UTC) |
| Bad characters in page titles | occasionally (test run) | 09:05, 28 February 2025 (UTC) |
| TimedText pages to be checked | occasionally (test run) | 03:36, 08 February 2025 (UTC) |
| Users | ||
| Commons contributors by edit count | 11:04, 10 March 2025 (UTC) | |
| Commons contributors by number of uploads | 01:29, 18 October 2024 (UTC) | |
| Users active in last 30 days with 10,000 edits and those recently inactive | 01:06, 18 October 2024 (UTC) | |
| Active in last 30 days with 1,000 edit, not in a local group and not blocked | Daily | 04:43, 03 May 2023 (UTC) |
| Noticeboard stats | Daily | 12:01, 08 September 2023 (UTC) |
| Blank user talk pages for IPs | Weekly | 05:02, 09 October 2022 (UTC) Edit by BernsteinBot
|
| Blocked users in user groups | Semimonthly | 05:25, 25 April 2025 (UTC) Edit by MDanielsBot
|
| Inactive users in user groups | Semimonthly | 05:31, 19 January 2015 (UTC) |
| Miscellaneous | ||
| Page count by namespace | Daily | 07:09, 25 March 2023 (UTC) |
| Pages with the most revisions | Monthly | 04:15, 30 May 2018 (UTC) |
| Statistic of edits in the MediaWiki namespace | Daily | 10:19, 24 April 2025 (UTC) |
| Users by log action | Daily | 02:30, 25 April 2025 (UTC) |
| Users by log action (Translation) | Daily | 06:10, 21 March 2025 (UTC) |
| Meta categories count by suffix | Daily | 01:29, 05 February 2024 (UTC) Edit by W like wiki
|
| Abuse filter effectiveness | Daily | 08:24, 28 April 2024 (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.