Plex DB query help - extracting codec and filepath info

Plex Media Server Desktops & Laptops
,
1

Hi Everyone, I’m in the process of trying to standardize my library to make my LG TV “just play” everything with minimal hassle. As such I’m trying to automate some trans-coding and my first “big hit” is going to be getting all media to have a plain Stereo AAC as the first Channel, as my TV has issues with more strenuous than that. I’ve found this thread already, which is a good start, but I’m still struggling to find some good resources on the schema of the database so I can create my own queries. Request: Dolby Atmos and DTS:X indicators and filters

Is anyone able to help point me in the right direction so I generate a query to give an output like the following:
File-path, Resolution, FileSize, Audio-Codec1 Audio-Codec2, Audio-Codec3, VideoCodec

So that I can take that result and throw it at another script to sort out what files need work, and eventually throw them at an automated Task to remux them to be direct play ready?

2

Check out Export Tools.
https://forums.plex.tv/t/how-to-export-all-your-plex-libraries-to-excel-xl-easy-solution/396933/2

3

Thank you, I knew there had to be a reason why I couldn’t find this. Its already a solved problem.

4

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