Finding movies in Emby that do not have English audio?

[Crestj 68]

I came across a few movies by accident that I'd ripped with the wrong language audio and would now like to find any others.

 

I've checked the Reports plug-in but this details "audio" as the codec used.

 

The details page for an individual movie shows which language the audio is but I don't seem to be able to search for this across a library.

 

Any ideas?

[PenkethBoy 2068]

Couple of ideas

 

if you save your metadata with your media then a text search for the <language>xxx</language> with xxx as the short code for the language in question or not eng, und or ...... - fiddly as you may have other tracks that are non english that may not be the default etc

 

Other option is a SQL query between the "mediastreams" table and the "TypedbaseItems" table - less fiddly if you are familiar with sql and you can be more specific in your search to limit false positives

 

Something like this using the free "DB Browser for SQLite"

Select mediastreams.StreamType, mediastreams.Language, mediastreams.IsDefault, TypedBaseItems.Name, TypedBaseItems.Path

from mediastreams, TypedBaseItems

where (mediastreams.ItemId = TypedBaseItems.guid) and (mediastreams.Language <> "eng" and mediastreams.Language <> "und" and mediastreams.Language NOT NULL)

order by TypedBaseItems.Name

 

partial listing from my collection

 

Have fun

[Crestj 68]

Couple of ideas

 

if you save your metadata with your media then a text search for the <language>xxx</language> with xxx as the short code for the language in question or not eng, und or ...... - fiddly as you may have other tracks that are non english that may not be the default etc

 

Other option is a SQL query between the "mediastreams" table and the "TypedbaseItems" table - less fiddly if you are familiar with sql and you can be more specific in your search to limit false positives

 

Something like this using the free "DB Browser for SQLite"

Select mediastreams.StreamType, mediastreams.Language, mediastreams.IsDefault, TypedBaseItems.Name, TypedBaseItems.Path

from mediastreams, TypedBaseItems

where (mediastreams.ItemId = TypedBaseItems.guid) and (mediastreams.Language <> "eng" and mediastreams.Language <> "und" and mediastreams.Language NOT NULL)

order by TypedBaseItems.Name

 

partial listing from my collection

 

Have fun

Perfect!

 

Didn't think to try a sql query!

 

Thanks

 

Sent from my F8331 using Tapatalk

[PenkethBoy 2068]

No problem - remember to shut down your server first to either make a copy of your db file or prevent errors due to db "locking" by emby