A script for Windows Disk Estimation.
Hi,
I need to implement a script by which I can get the windows disk used space and available space.
In brief; If I have 4 disks on my SQL Server, so using one script I can get all the used space and available space for all the 4 drives.
Lets take an Example : If disc C contains total of 100 GB space and out of it 80 GB is used so 20 GB is left, and after running query I get the result as C available space is 20 GB and used space is 80 GB and total space is 100 gb.
Please Help,
Thanks In Ad
February 8th, 2014 5:23am
February 8th, 2014 5:43am
February 8th, 2014 7:01am
I am sorry to say that it will not work, because XP_fixeddrives will provide only free space on your drives, while I need full size, available space, occupied space of drives.
February 8th, 2014 11:50am
Full size you could propably lookup manually an put into the calculation. So now you got full size and free space, so now you calculate used space - I do not get what will not work?
February 8th, 2014 3:23pm
February 8th, 2014 9:29pm
Other recent topics
