SQL Query : Check space occupied by database files

SELECT 
	RTRIM([name]) AS [Segment Name], 
	[groupid] AS [Group Id], 
	[filename] AS [File Name],
	CAST([size]/128.0 AS DECIMAL(10,2)) AS [Size in MB],
	CAST(FILEPROPERTY([name], 'SpaceUsed')/128.0 AS DECIMAL(10,2)) AS [Space Used],
	CAST([size]/128.0-(FILEPROPERTY([name], 'SpaceUsed')/128.0) AS DECIMAL(10,2)) AS [Available Space],
	CAST((CAST(FILEPROPERTY(name, 'SpaceUsed')/128.0 AS DECIMAL(10,2))/CAST(size/128.0 AS DECIMAL(10,2)))*100 AS DECIMAL(10,2)) AS [Percent Used]
FROM 
	[sysfiles]
ORDER BY 
	[groupid] DESC