How to find "Unmatched" movies?

General Discussions
1

How to find “Unmatched” movies?
Is there a way to filter unmatched movies?

2

How to find the discrepancy between number of files on disk and the number of movies in the Plex movie library

4

I found the following way to do this using a terminal, might be useful to others too since this thread is one of the top google results. I’ve only done it on a Mac, should work as long as you have access to a terminal and sqlite3.

First, open the database using the sqlite3 tool by running this in a terminal window (e.g. open Terminal.app on a Mac):

sqlite3 ~/Library/Application\ Support/Plex\ Media\ Server/Plug-in\ Support/Databases/com.plexapp.plugins.library.db

Second, run the following query:

SELECT title FROM metadata_items WHERE guid LIKE 'local://%';

That’s it.

1 Like