Espaço em disco (disponível) via SQL

Dois exemplos:

Via procedure:

EXEC master.dbo.xp_fixeddrives; 

Via tabelas do sistema:

SELECT DISTINCT

    VS.volume_mount_point [Montagem] ,

    VS.logical_volume_name AS [Volume] ,

    CAST(CAST(VS.total_bytes AS DECIMAL(19, 2)) / 1024 / 1024 / 1024 AS DECIMAL(10, 2)) AS [Total (GB)] ,

    CAST(CAST(VS.available_bytes AS DECIMAL(19, 2)) / 1024 / 1024 / 1024 AS DECIMAL(10, 2)) AS [Espaço Disponível (GB)] ,

    CAST(( CAST(VS.available_bytes AS DECIMAL(19, 2)) / CAST(VS.total_bytes AS DECIMAL(19, 2)) * 100 ) AS DECIMAL(10, 2)) AS [Espaço Disponível ( % )] ,

    CAST(( 100 - CAST(VS.available_bytes AS DECIMAL(19, 2)) / CAST(VS.total_bytes AS DECIMAL(19, 2)) * 100 ) AS DECIMAL(10, 2)) AS [Espaço em uso ( % )]

FROM

    sys.master_files AS MF

    CROSS APPLY [sys].[dm_os_volume_stats](MF.database_id, MF.file_id) AS VS

--WHERE

--    CAST(VS.available_bytes AS DECIMAL(19, 2)) / CAST(VS.total_bytes AS DECIMAL(19, 2)) * 100 < 100;

Obs: O Where esta comentado.