One of my plex hard drives died. Is there any feature or external method that would allow me to easily generate a list of the movies that are no longer playable on plex/were stored on the dead hard drive? Looking for the quickest way to find out what movies I need to replace.
You can do this with a sqlite query. This page has some instructions on using sqlite on the plex database. It’s for how to correct a corrupt database but it covers some of how to use sqlite.
Anyway, if you want a list of filenames, this query will give you want you want:
select file from media_parts where file like 'pathPrefixHere%';
If you want the friendly titles, you can use this:
select distinct metas.title from metadata_items metas join media_items media on metas.id = media.metadata_item_id join media_parts parts on media.id = parts.media_item_id where parts.file like 'pathPrefixHere%';
I see from your tags you mention Windows and I’m not absolutely sure of path format that we store in the database for Windows so you’ll want to look at the file column in the media_parts table to see what they look like. Then you set pathPrefixHere to the path of the drive and run one of the above queries.
Hopefully that helps you out and good luck with your recovery.
WebTools FindMedia module was made for this
Besides that, ExportTools can do this as well, but vital for both is, that you switch off Empty Trash after scanning
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
