MSQL : Find location of DATA and LOG

file.sql

SELECT 
    d.name AS DatabaseName,
    mf.type_desc AS FileType,
    mf.physical_name AS FilePath
FROM 
    sys.master_files mf
JOIN 
    sys.databases d ON mf.database_id = d.database_id
WHERE 
    d.name NOT IN ('master', 'model', 'msdb', 'tempdb')  -- Exclude internal databases
ORDER BY 
    DatabaseName, FileType;