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. Ive 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 Ive 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 DBAs to monitor their mounted voulmes where they have hosted their database files.
In the script below Ive 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 Ive mounted a drive to C:Mounted Drive folder and executed the script.
Sample Output
Leave a Reply