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!!
Output would be like this
drive MB free