Today, I have to do a clean reinstall of the OS.  I needed to make sure I grab all the databases located on the machine regardless of where they are located.  They all should be in a specific folder, but to make sure I went in to get the path and file name for all the databases.  There are a number of databases and clicking on each database, selecting properties and then looking at the file groups would take a bit of time.

To expedite the process, I threw together this query.  Maybe it will be helpful to others:

select
  m.database_id, m.name, physical_name

from
sys.master_files as m join sys.databases as d
   on m.database_id = d.database_id

Trivial, but handy!