brandon.lukes (5/23/2012)
We do have a process to get disk/mount space via a powershell script. So we have that covered. I was just hoping that there was an easy replacement for xp_fixeddrives for this script.
for SQL 2008R2 or above, sys.dm_os_volumne_stats (database_id, file_id) can be the substitute for xp_fixeddrives. you will need to rewrite somewhat the OP's script though.