Finding mismatched movies?

[King Pin 34]

Is there a tool/plugin or something that can be run on a library to tell you about mismatched or incorrect movies? 

eg.  your filename is "Animal" but it's matched to "The Animal". 

 

I understand that proper naming conventions with dates is the best way to avoid this but when I first started out ripping my collection no dates were added.  

[Happy2Play 9782]

Not that I know of.  Only thing I can think of is maybe a database query comparing Filename to Name.

Movie

select Filename, Name from MediaItems where type=5

TV

select Filename, Name from MediaItems where type=6

 

Edited September 17, 2022 by Happy2Play

[King Pin 34]

Thanks Happy.  Unfortunately that sounds like it's a little over my head in techical abilities. 

[Happy2Play 9782]

Just need to make a copy of your library.db and open in a database viewer and run that query.