Display missing files from media server

I would like plex server to have a option to:

1: Display a list of videos that are in the DB, but missing the physical file
2: Display a list of videos where a file exists in the directories but missing in the DB.
3: Provide actions to correct 1 & 2 above