I'm looking to prepare an analysis based on disk growth to indicate when i would be running out of physical disk space on each of my sql server instances. I have not discovered a way yet to obtain the size of the physical disks.
I can obtain how much disk space is free on each drive by xp_fixeddrives but not yet the max space of the drive.
Has anyone been able to find a way to get this info thru sql?