Searching how a file has been inventoried

Server Version#: 1.22.1.4275
Player Version#: 4.53.0
Hi, do someone know how to locate how a file has been identified in Plex server? If I have thousands of files and I need to locate jus one of those and I cannot find it using a normal search in plax, since the search find just names coming out from internet databases, it there a way to find it?
Es: I need to find startrekvojagerep01.01.mkv since it has been erroneously inventoried…

I wonder how Plex could match that name incorrectly… sorry, sarcasm comes naturally but doesn’t suit me well :wink:

Inside Plex your best shot is to filter your library by duplicates. If the rest of your media is better prepared, you should be able to find it that way. An alternative might be to remove the file, scan your library and empty the trash in order to start over with that show.

If you need to dig deeper into that beehive… there’s apps like Web Tools / Export Tools that you can use to create an overview of your server content – including file names and what they’re associated with.

2 Likes

Congratulations - you win the Worst TV Show Name Contest - hands down.

I’m not surprised Plex lost it.

It’s very likely (almost a guarantee) it’s now a duplicate of another episode since Plex couldn’t identify it with that name you gave it - and guessed wrong.

Filtering for Episode Duplicates with the provided means is… difficult.

I think Tom’s idea of removing that item entirely - renaming it and everything else in Star Trek Voyager according to the instructions - and starting over - is sound advice and probably faster than all other means:

I don’t have Voyager (why is that, I wonder?), but when I do it’ll look something like this:

I use Filebot - and I read the instructions:

1 Like

I second the suggestions to fix your file naming (wow, indeed), search for duplicates, and remove/replace the file.

Another technique that can be helpful is to view your library by Folders (instead of TV Shows / Seasons / Episodes / Movies).

Navigate to your known file, and you should get some hints about what it’s been matched with.

1 Like

I just tried filtering ‘Episodes’ then ‘Duplicates’ - and then came up the word ‘Difficult’ 'cause it’s very likely it’ll never be found that way…

I hope your way bears edible fruit.
My way - not so much.

I’d go for the:
Do-Over.

If this is a show that you just added, you could also sort the library by “Date Added.” It would then be at or near the top of the list.

1 Like
SELECT md.*,p.file FROM metadata_items md 
inner join media_items m ON m.metadata_item_id=md.id 
inner join media_parts p on m.id=p.media_item_id 
WHERE p.file like '%startrekvojagerep01.01.mkv'

Will return the info on what show, if it actually matched it to a show, that plex matched your file to

2 Likes

Thanks @tom80H for the tips. I will try Web Tools and check if they will fit my need.

I also need to chill down all answers: I just wrote a random name, I should have written “wowyetclax.wav” or “aaaa.bbb”, the scope was to find out how it was stored in Plex db a particular file, not at all important what was the name of the file, of course.

However if you are interested in some more info, I now have problems with a correct naming convention that is not at all recognized: “Doctor Who (1963)” and “Doctor Who (2005)” are the two folders, correctly named (TheTVdb), that Plex merge in just one. Tried to divide them however it did not work so I ned to figure out where all files resides in PLex db to start the debug.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.