SELECT DISTINCT d.logical_volume_name

,d.volume_mount_point

,CAST(d.total_bytes / 1024 / 1024.0 AS INT) AS TotalMB

,CAST(d.available_bytes / 1024 / 1024.0 AS INT) AS FreeMB

FROM sys.master_files f

CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id) d

---------------------------------------------------

Now above query is working. example if we have 5 servers i need all the servers disk space information in one query.