If for any reason you find yourself with random missing tracks, (or are trying to recover from a dying hard drive like me), there is an easy way to isolate those missing tracks.

1. Create a standard playlist called “Not Missing”.
2. Drag your entire library into that playlist. Missing tracks cannot be copied to a playlist.
3. Create a smart playlist called “Missing” where Playlist – is not – Not Missing.

Voila! All your missing tracks with the dreaded exclamation mark are now in a playlist. You have three options:
1. Delete them
2. Reconnect them by manually finding the proper files.
3. Reimport your CDs, which will retain the ratings and playcounts, etc.