OS X 10.8 and later only. This script checks your entire iTunes library for missing and presumed dead tracks--those tracks that iTunes is unable to associate with a file and which are listed in iTunes with a "!"--and can create a text file listing these tracks by alleged File Path (if available), Song Name, Artist and Album, which you can view using TextEdit.
Also see Music Folder Files Not Added
To find and delete dead tracks see Super Remove Dead Tracks.
See the video on YouTube.
iTunes can't find the files pointed to by the Location property of these track entries.
Change case of selected track names to sentence caps
Emulates iTunes search and copies results to a playlist
Renumber order of selected tracks
Create playlists by artist
Search YouTube using tag info from selected or playing track
Move selected playlists to a new or existing folder