Gets info about all the files in a specific filegroup

FilegroupFilesInfo.sql

SELECT
	a.FILEID As FileID,
	a.groupid AS FileGroupID,
	a.[name] AS LogicalName,
	a.[filename] AS FilePath,
	ROUND(CAST(a.size AS FLOAT)/128,2) AS Reserved_MB,
	ROUND(CAST(FILEPROPERTY(a.name,'SpaceUsed') AS FLOAT)/128,2) AS Used_MB,
	ROUND(CAST(a.size AS FLOAT)/128 - CAST(FILEPROPERTY(a.name,'SpaceUsed') AS FLOAT)/128,2) AS Free_MB
FROM dbo.sysfiles a
WHERE a.groupID = 16
ORDER BY Reserved_MB DESC;