In my previous article on “Diskspace Check via SQLServer” will find only physical \ logical drives that is attached to the system i.e the drive which you see under my computer. I’ve used this script in one of my client machine and found that this script is not capable to check disk space for mounted drives. Hence I’ve written an WMI script and SQL Script (like version 1) to fetch both physical disk & mounted disk space details. I hope this would help most of the DBA’s to monitor their mounted voulmes where they have hosted their database files.
In the script below I’ve just provide you the output of total disk space, free space details. You can modify the SQL Script further to suite for your requirement.
Version : 2
How to Use
- Download both the scripts and save it to your local drive
- In SQL Script you need to change the parameter @VBSPATH to the path where you have stored the WMI Script including the file name
- Save the script
- Use the modified SQL Script to know the disk details
To shown an example I’ve mounted a drive to C:\Mounted Drive\ folder and executed the script.
Sample Output
Comments are closed.