Free space fixed drives

IF OBJECT_ID('tempdb..#drives') IS NOT NULL
    DROP TABLE #drives

CREATE TABLE #drives (
        drive char,
        [free] int
)
      
INSERT INTO #drives
EXEC master..xp_fixeddrives

SELECT drive, [free] / 1024 as FreeSpaceGB
FROM #drives


Till Next Time