Detalle de espacio utilizado por las bases de datos de un servidor sql server

select 

    d.name as DatabaseName,

    a.name as FileName,

    FG.name as FileGroup,

    a.physical_name as FilePath,

    a.type_desc as FileType,

    CONVERT(DECIMAL(12,2),ROUND(a.size/128.000,2)) AS [Size],

    CONVERT(DECIMAL(12,2),ROUND(FILEPROPERTY(a.name,'SpaceUsed')/128.000,2)) AS [Used] ,

    CONVERT(DECIMAL(12,2),ROUND((a.size-FILEPROPERTY(a.name,'SpaceUsed'))/128.000,2)) AS [Free]

from sys.databases d

left join sys.master_files a on d.database_id = a.database_id

left join sys.filegroups FG on

    FG.data_space_id = a.data_space_id;