you just need to run the following script on the database you need this information

SELECT F.name AS NameOfFile,

G.groupname,

  F.size/128.0 SpaceinMB,

  F.size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB,

  ((F.size/128.0 -CAST(FILEPROPERTY(name,...