Easy way to isolate missing media and delete?

[colinjones]

I have a lot of media in my database that is "missing" because I have renamed the files to get rid of bad characters. But they are spread out all over the share. Is there a sql query I can use to safely select them all and delete them? Also, is the flag to mark "missing from disk" the same as that used to flag files on devices that are offline?