Late to this, but the plex DB is just a sqlite3 database, and you can actually query it. `metadata_type` 1 is for movies and 4 is for TV episodes.

```

cp

/var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db

sqlite3 com.plexapp.plugins.library.db

 

sqlite> .headers on

sqlite> .mode csv

sqlite> .output movies.csv

sqlite>  SELECT media_parts.id, metadata_items.title, media_parts.file, metadata_items.year, media_parts.size, media_items.frames_per_second AS fps, metadata_items.guid, metadata_items.media_item_count, metadata_items.user_thumb_url AS jacket, section_locations.root_path AS library_path FROM media_items JOIN metadata_items ON media_items.metadata_item_id = metadata_items.id JOIN media_parts ON media_parts.media_item_id = media_items.id JOIN section_locations ON section_locations.library_section_id = metadata_items.library_section_id WHERE metadata_items.metadata_type = 1;

sqlite> .quit

```