select distinct 
    b.logical_volume_name logical_name
,   upper(b.volume_mount_point) drive
,   b.total_bytes / 1024 / 1024 / 1024 total_space
,   b.available_bytes / 1024 / 1024 / 1024 free_space
from sys.master_files a
    cross apply sys.dm_os_volume_stats(a.database_id, a.file_id) b