Free disk space in a cluster

Question

Hi,

is there a way to restrict the result of xp_fixeddrives only to those drives the SQL Server cluster group has a dependency on? Or, to say more generally, how can one find out the free disk space available for remote clustered SQL Server using only TSQL?

Thanks a lot.

 

 

Answer 1

try:

select * from fn_servershareddrives()

or

select * from sys.dm_io_cluser_shared_drives