Search for duplicate movies

[gsites 14]

hello,

I'm looking for the answer but I couldn't find it on the forum.

Is there any way to search for duplicate movies without installing plugin to group movies?

Thank you

[Carlo 4561]

Hi, there is no easy way to do this but at least 2 ways to accomplish this.

One is via SQL against the library.db file but you need a SQL tool and need to run this when Emby Server is shut down or against a copy of the database.  This is my preferred method.

The other way is using a plug to generate a list of all movies and then looking for dupes.

[gsites 14]

9 hours ago, cayars said:

Hi, there is no easy way to do this but at least 2 ways to accomplish this.

One is via SQL against the library.db file but you need a SQL tool and need to run this when Emby Server is shut down or against a copy of the database.  This is my preferred method.

The other way is using a plug to generate a list of all movies and then looking for dupes.

Thank you very much for your answer, using SQL is perfect for me.
Do you know any software or app that is good for editing the library.db file?
Your answer is helping me a lot.

Thanks again

[Carlo 4561]

DBBrowser for Sqlite

This is what I use but I exclude 3D and 4K files (I keep 3D and 4K in the name)

select Name, ProductionYear from MediaItems where type=5 and Path not like '%4k%' and Path not like '%3D%' and Path not like '%extra%' group by Name || ProductionYear having count(Name || ProductionYear) > 1;

 

[Happy2Play 9784]

Note Emby has to be shutdown in order to open the library.db properly.  I would suggest ensuring you have a backup of your library.db before doing anything.