for file in mysql dbname -e "SELECT filename FROM system" | sed "1d"; do [ ! -f $file ] && echo $file; done
This lists all the files from the system table that do not exist in the actual file system anymore.
In our experience, this more often mean modules with bad uninstall practices, rather than modules deleted without uninstalling.
See also Enabled Modules
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution 3.0 Unported License.