Find physical server locations for File Streams

FileStreamLocations.sql

SELECT		t.name AS 'table',
		c.name AS 'column', 
		fg.name AS 'filegroup_name', 
		dbf.type_desc AS 'type_description',
		dbf.physical_name AS 'physical_location'
FROM		sys.filegroups fg
INNER JOIN	sys.database_files dbf
ON		fg.data_space_id = dbf.data_space_id
INNER JOIN	sys.tables t
ON		fg.data_space_id = t.filestream_data_space_id
INNER JOIN	sys.columns c
ON		t.object_id = c.object_id
AND		c.is_filestream = 1