SQL DBA - TSQL to get current location of all data and log files of all databases of the server

SELECT name, physical_name AS current_file_location

FROM sys.master_files