Identify failed file uploads

[grahamjevon]

Sometimes file uploads fail (e.g. if the file size is too big). The failure is not always obvious because the file metadata is added (even if the actual file is not). Sometimes the file will be listed as an item within a work, but the actual file is not available for download. An indicator of such an instance is an item with no filesize. I have fixed all the known instances. Is there a script that can be run to find any other instances?

In this screenshot below, the file is ok because it says it is 400MB, but if this field was empty, it would be an indicator that an error had occurred.