All the database files of an MSSQL instance

SELECT
       physical_name as path
FROM
       sys.databases AS db
       INNER JOIN sys.master_files AS mf ON db.database_id=mf.database_id;
GO