Get database file info

File names and paths for all user and system databases on instance

SELECT DB_NAME([database_id]) AS [Database Name]
	,[file_id]
	,[name]
	,physical_name
	,[type_desc]
	,state_desc
	,is_percent_growth
	,growth
	,CONVERT(BIGINT, growth / 128.0) AS [Growth in MB]
	,CONVERT(BIGINT, size / 128.0) AS [Total Size in MB]
	,max_size
FROM sys.master_files WITH (NOLOCK)
ORDER BY DB_NAME([database_id])
	,[file_id]
OPTION (RECOMPILE);

master_files