Or this one :-

USE DatabaseName

SELECT [name] as PhysicalFileName, SUM(size) / 128.00 AS [Total (Mb)],

SUM(ISNULL(FILEPROPERTY([name], 'SpaceUsed') / 128.00, 0)) AS [Used (Mb)],

CASE...