• Did you try this ?

    SELECT distinct

    vs.volume_mount_point

    , vs.volume_id

    , vs.logical_volume_name

    , vs.file_system_type

    , vs.total_bytes / 1048576 AS 'MBTotal'

    , vs.available_bytes / 1048576 AS 'MBAvailable'

    , CAST( 1.00 * vs.available_bytes / vs.total_bytes * 100 as decimal(5,2) ) as pctFree

    , vs.supports_compression

    , vs.supports_alternate_streams

    , vs.supports_sparse_files

    , vs.is_read_only

    , vs.is_compressed

    FROM [sys].[master_files] AS f

    CROSS APPLY [sys].[dm_os_volume_stats]([f].[database_id], [f].[file_id]) AS vs

    ORDER BY [vs].[logical_volume_name] ;

    Of course, this will only provide information about drives to which the sqlinstance has databases allocated.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me