Finding available free space in the disks of SQL Server

Introduction

As part of regular maintanence we needed to send a weekly report that included available harddisk space in our PROD SQL Server. This required a remote desktop login to the restrictive PROD environment and checking the space. We were unable to automate the status checks due to this particular item, after months of doing this as a manual activity found out that a simple procedure call will return the hard disk space from the Server machine.

Using the code

Just run the below procedure, no input parameters required!!

xp_fixeddrives

Output would be like this

drive MB free
----- -----------
C     31450
D     450047