Audio stream in database

Plex Media Server
1

hopefully a simple question but wasn’t obvious where to place it topic-wise…

I recently added a bunch of movies and realized that not all have an English audio stream (dubbed into Russian for example).

I was poking around the PMS database but I couldn’t find where the audio language was stored for a particular media file.

I’m hoping to run a query and get back a list of movies that don’t have an English audio stream.

Thanks in advance!

2

No need for a query. Just create a custom filter.

image
image998×194 70.5 KB

Keep in mind that if the language is not set, it will be seen as unknown. Or you can do the opposite and look for ones only in a foreign lanaguage. You’ll be shown a list of language so you don’t need to know what they are, just pick them from the list.

image
image1010×184 63.8 KB

3

Oh great, thanks for that…I didn’t even realize that the smart playlists were so powerful!

While I’m here, a few more questions/improvements:

  • I don’t see a way to filter on “Unknown”. There is a “Not Applicable” item in the language list, but it seems no “Unknown” option?
  • Unrelated to filtering, is there any (easy?) way to remove audio streams from a file? I have a couple that have both English and another one and it would make filtering a bit easier going forward if I could remove the non-English one where appropriate.
  • A minor bug, when selecting a language from the list, that language isn’t removed from the selection list so it’s hard to see which ones are already selected or not.

Thanks again for your help!

4

Get MKVtoolnixGUI
drag the media file into it,
disable all the tracks you don’t want
‘Start Muxing’

The result is a MKV file which has the streams from your original file unchanged (i.e. no quality degradation), minus the tracks you disabled.

5

1 - You can’t since “unknown” is not an actual language. That’s just what Plex shows when the language field is blank. There isn’t a way to look for blanks but you can look for not something like in my example above. “Not English” will show unknown.

2 - See comment above.

3 - It doesn’t do that. Maybe try doing a few at a time only.

6

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