# Filtering missing tracks **URL:** \ **Category:** Engine DJ (Mac & PC)\ **Created:** [October 19, 2026, 11:24am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336 "2026-10-19T11:24:56Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Nils\_Stump](https://community.enginedj.com/letter_avatar_proxy/v4/letter/n/b782af/32.png) [@Nils\_Stump](https://community.enginedj.com/u/Nils_Stump)\ **Post date:** [October 19, 2026, 11:24am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/1 "2026-10-19T11:24:56Z")
Hi All, My collection contains a big number of tracks. Recently, i reorganized those in the file system (PC). Now, i am stuck with a few unrecognizable items across the whole collection. Is there a way to filter for those? Scrolling through the whoe collection is a nightmare. BTW, for me the auto-relocate doesn’t work at all. Thanks in advance. Nils ---
**Author:** ![djliquidice](https://community.enginedj.com/user_avatar/community.enginedj.com/djliquidice/32/18391_2.png) [@djliquidice](https://community.enginedj.com/u/djliquidice)\ **Post date:** [October 19, 2026, 2:57pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/2 "2026-10-19T14:57:55Z")
> [@Nils\_Stump](#): > > BTW, for me the auto-relocate doesn’t work at all. Thanks in advance. Hi @Nils_Stump ! Welcome to the forum. Auto-relocate has seemed to have gotten an upgrade a few revisions ago. I’m using 5.0, what version are you using at this time? Of the songs you relocated, are those songs located on the same physical volume? ---
**Author:** ![Nils\_Stump](https://community.enginedj.com/letter_avatar_proxy/v4/letter/n/b782af/32.png) [@Nils\_Stump](https://community.enginedj.com/u/Nils_Stump)\ **Post date:** [October 20, 2026, 1:33pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/3 "2026-10-20T13:33:15Z")
I am using 5.1.0. on PC. All files are in the “Music” folder on the main Windows drive organized in Subfolders. ---
**Author:** ![djliquidice](https://community.enginedj.com/user_avatar/community.enginedj.com/djliquidice/32/18391_2.png) [@djliquidice](https://community.enginedj.com/u/djliquidice)\ **Post date:** [October 20, 2026, 3:15pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/4 "2026-10-20T15:15:34Z")
And when you right click any file in the main collection and choose auto relocate, that doesn’t fix the issue? ---
**Author:** ![Nils\_Stump](https://community.enginedj.com/letter_avatar_proxy/v4/letter/n/b782af/32.png) [@Nils\_Stump](https://community.enginedj.com/u/Nils_Stump)\ **Post date:** [October 20, 2026, 3:28pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/5 "2026-10-20T15:28:25Z")
Nope, doesn’t. File is located in a subfolder of c:\users\myUser\music\archive… ---
**Author:** ![Mazkouth](https://community.enginedj.com/letter_avatar_proxy/v4/letter/m/3bc359/32.png) [@Mazkouth](https://community.enginedj.com/u/Mazkouth)\ **Post date:** [October 23, 2026, 4:16am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/6 "2026-10-23T04:16:35Z")
I use a third party app named engine prime cleaner. It does scannyour collection and delete the red ones! The app is from atgr production if i’m remember well ---
**Author:** ![Thomas\_Prando](https://community.enginedj.com/letter_avatar_proxy/v4/letter/t/ecd19e/32.png) [@Thomas\_Prando](https://community.enginedj.com/u/Thomas_Prando)\ **Post date:** [October 24, 2026, 1:49am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/7 "2026-10-24T01:49:41Z")
Where do you get that?? ---
**Author:** ![androphonic](https://community.enginedj.com/user_avatar/community.enginedj.com/androphonic/32/22602_2.png) [@androphonic](https://community.enginedj.com/u/androphonic)\ **Post date:** [October 24, 2026, 2:12am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/8 "2026-10-24T02:12:17Z")
Engine Prime Cleaner was offered by @MixMasterG as a download almost a decade ago. It’s not available now. Engine DJ has changed very much since then, so even if you found a copy you wouldn’t want to use it. Those features **may** be available in MixMasterG’s DJ Conversion Utility (Mac only). That is for purchase on the [ATGR.nl](https://atgr.nl) site. [LexiconDJ](https://www.lexicondj.com/) will allow you to filter all of your missing tracks and help relocate them. There are three versions, Free, Essential and Ultimate. I know the Free version won’t do it. I have Ultimate and it will. Some of the other library management software like [Mixo](https://www.mixo.dj) might also do that. BTW- I asked “AI” for tricks and it gave flat out bogus advice. Be sure to open the “Directory” column in your Engine DJ library browser. It may give you a clue as to what folders are not being located. There are quite a few discussions and feature requests on this topic. Check this out with 31 votes: [https://community.enginedj.com/t/bulk-delete-of-red-tracks-in-engine-dj-app/37572](https://community.enginedj.com/t/bulk-delete-of-red-tracks-in-engine-dj-app/37572) ---
**Author:** ![Mazkouth](https://community.enginedj.com/letter_avatar_proxy/v4/letter/m/3bc359/32.png) [@Mazkouth](https://community.enginedj.com/u/Mazkouth)\ **Post date:** [October 24, 2026, 7:13am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/9 "2026-10-24T07:13:19Z")
I use engine prime cleaner until now! It works perfectly for my purpose : remove (not relocate) all red tracks at once ---
**Author:** ![androphonic](https://community.enginedj.com/user_avatar/community.enginedj.com/androphonic/32/22602_2.png) [@androphonic](https://community.enginedj.com/u/androphonic)\ **Post date:** [October 24, 2026, 2:15pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/10 "2026-10-24T14:15:47Z")
So then, this is good to know. It’s still helpful for those who want to clean out “missing“ tracks in the database. If it generates a list of the tracks, without removing them from the database, that would help people find which tracks are not being found. ---
**Author:** ![androphonic](https://community.enginedj.com/user_avatar/community.enginedj.com/androphonic/32/22602_2.png) [@androphonic](https://community.enginedj.com/u/androphonic)\ **Post date:** [October 24, 2026, 5:13pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/11 "2026-10-24T17:13:49Z")
Ok, so if you have a Mac, I did some back and forth with AI and got this bash script to list missing files sorted by path to a desktop file “missing\_tracks.txt”. ```auto bash sqlite3 "/Users/$(whoami)/Music/Engine Library/Database2/m.db" "SELECT '/Users/$(whoami)/Music/Engine Library/' || path FROM track WHERE path IS NOT NULL AND path != '';" | while read -r f; do p=$(echo "$f" | sed 's|/Engine Library/\.\./|/|g'); [! -f "$p"] && echo "$p"; done | sort > ~/Desktop/missing_tracks.txt ``` **Use code with caution.** Copy the two lines, open Terminal and past the block in there. I moved some files around it, worked for me. Others with computer savvy, if it doesn’t work right for you, please step in. ---
**Author:** ![androphonic](https://community.enginedj.com/user_avatar/community.enginedj.com/androphonic/32/22602_2.png) [@androphonic](https://community.enginedj.com/u/androphonic)\ **Post date:** [October 24, 2026, 5:45pm UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/12 "2026-10-24T17:45:06Z")
Another version that runs in zsh. I saved it as EngineDJ\_MissingFiles.zsh and just drop it on Terminal when I want to run it. ```auto sqlite3 "/Users/$(whoami)/Music/Engine Library/Database2/m.db" "SELECT REPLACE('/Users/$(whoami)/Music/Engine Library/' || path, '/Engine Library/../', '/') FROM track WHERE path IS NOT NULL AND path != '';" | while read -r p; do [! -f "$p"] && echo "$p"; done | sort > ~/Desktop/missing_tracks.txt ``` EDIT: all of my music is on the local drive, so I’m not sure if the substitution works correctly, if your library is stored on a connected drive. ---
**Author:** ![DjFurri](https://community.enginedj.com/letter_avatar_proxy/v4/letter/d/7ea924/32.png) [@DjFurri](https://community.enginedj.com/u/DjFurri)\ **Post date:** [November 1, 2026, 9:19am UTC](https://community.enginedj.com/t/filtering-missing-tracks/71336/13 "2026-11-01T09:19:06Z")
A mi me paso lo mismo, hice limpieza de archivos de baja calidad y me ha costado la vida dejar la biblioteca sin ningún archivo rojo, yo utilice lexicon ultimate, vale la pena pagar algún mes y dejarte la biblioteca a tu gusto.