Getting DATA & LOG File information of ALL Database in SQL SERVER

Getting DATA & LOG File information of ALL Database in SQL SERVER

This helps to get all the data and log file information like physical path.size etc  of all databases available in the server.

EXECUTE master.sys.sp_MSforeachdb 'USE [?]; EXEC sp_helpfile'

Thanks :)