Export database to csv or excel

I recently lost a hdd that housed a lot of my library. Is there anyway to see what files in my library were located on that lost harddrive, so that i know which ones to replace?

I think ExportTools (WebTools-NG) should be able to provide you with the information you need.