Find the location of MS SQL MDF and LDF files

Run the following query against the Master DB to return the location of User DB file locations. You can then select all in the results pane and paste into Excel.

select name,physical_name from sys.master_files where database_id > 4