A SQLite query to extract metadata of your plex library. I wanted a way to view information about my media directly from the plex media library. I know there are softwares out there than can scan your raw media files but i need this information all in once place to easily filter on bits I wanted to check such as upgrading some of my lower quality videos etc. I have created the attached SQL script that extracts the data that i need:
Media Items ID
Metadata Items ID
Title (With Episode numbers and year)
TV Show Title (With Season number and year)
Library Name (With section ID)
Duration
File Size (MB)
Bitrate (Kbps)
Resolution
Container
Video Codec
Audio Codec
Audio Channels
I would really like to also display the play count for all plex users combined against each media file but I can’t figure out an accurate way to do this. Would appreciate some help on this if anyone is aware. Plex_Metadata_Export_Query.txt (3.4 KB)
I am aware Tautulli can readly do the above but it doesn’t work that great for TV Shows and you are limited to viewing 100 rows at a time.
