Lists the SQL Server databases and their corresponding file locations.

Audit_Database_Files.sql

SELECT db.[name], mdf.[physical_name] AS [Data File], ldf.[physical_name] AS [Log File]
  FROM [master].[sys].[databases] db
  INNER JOIN [master].[sys].[master_files] mdf ON db.[database_id] = mdf.[database_id] AND mdf.[type] = 0
  INNER JOIN [master].[sys].[master_files] ldf ON db.[database_id] = ldf.[database_id] AND ldf.[type] = 1
  --WHERE lower(mdf.[physical_name]) LIKE 'c%' OR lower(ldf.[physical_name]) LIKE 'c%'
  ORDER BY db.[name]