In the table metadada_items there is a column user_clear_logo_url, where you can see which media has clear logos.
If they have been uploaded by the user - I’ve uploaded some - it will have a value like this: upload://clearLogos/f335c38018830d9bd896a3e97611e792ab98246d.
If they have been fetched by Plex, it will be something like this:
metadata://clearLogos/tv.plex.agents.series_fc113ccf9102b3af0ed2e351ca264b5c336fc8e2
If the logo is missing, the value will be blank or possibly NULL .
I’ve put something together, if anyone is interested.
For TV Shows
SELECT title,
strftime('%Y', originally_available_at, 'unixepoch', 'localtime') AS year
FROM metadata_items
WHERE library_section_id = 2
AND media_item_count = 0
AND (
user_clear_logo_url = ""
OR user_clear_logo_url IS NULL
)
AND parent_id IS NULL
AND guid NOT LIKE '%collection%'
ORDER BY title_sort ASC;
In this case, library_section_id = 2 is my TV Shows library.
For Movies
SELECT title,
tags_director,
strftime('%Y', originally_available_at, 'unixepoch', 'localtime') AS year
FROM metadata_items
WHERE library_section_id = 1
AND media_item_count = 1
AND (
user_clear_logo_url = ""
OR user_clear_logo_url IS NULL
)
AND guid NOT LIKE '%collection%'
ORDER BY title_sort ASC;
In this case, library_section_id = 1 is my Movies library.
I’m not that sharp at SQLite but trying this with DB Browser for SQLite gives me correct results. Media that does not have logo but text.
You can get a nice report using DB Browser for SQLite.
Make a copy of your db - just to be safe -, open the db with DB Browser, copy & paste the code in the tab ‘Execute SQL’ and click on the arrow.
Then you can copy the formatted table in Excel.