Is there anyway to see how many videos still need preview thumbnails generated?

Plex Media Server Desktops & Laptops
1

Server Version#: 1.13.9.5456

With the introduction of the new mpv player in the iOS and tvOS Plex app there’s now a reason for me to generate preview thumbnails for all the videos in my library. I’ve set my server to start generating thumbnails as a scheduled task, but there’s a lot of videos in my library and I’m curious how far through this process I am.

So is there any way for me to get a count of the videos in my library that still need thumbnails generated for them? It’d also be nice if I could get a count of the videos that do have thumbnails, in order to know what percentage of them are done.

I’m guessing this requires making a query directly to my Plex library’s sqlite database, but if there’s a simpler way that’d be even better.

2

ExportTools

To see the manual, look here:

And you need as a min. level 5, and then look for the column named Part Indexed

3

I gave ExportTools a try and it doesn’t really seem to be that useful for what I want to do. Exporting the parts of my library produces some unwieldy and huge spreadsheets. Also I’m not sure what the values in Part Indexed represent.

Is there something else I can do with ExportTools that I’m missing? Also I still think there’s a query I can make to Plex’s database that’ll do what I want more directly. I’m just not sure what it is. (e.g. Which field in which table has what I want?)

4

If the column contains sd then it’s indexed, and if not, still pending

And regarding the amount of columns, simply delete the ones you don’t need afterwards. (Shouldn’t take more than a sec. to do that)

1 Like
5

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