September 16, 2010 at 3:54 pm
How do you monitor free space in a mount point?
xp_fixeddrives only works for disks... not for mount points. Any ideas on how to do this?
A.J.
DBA with an attitude
October 6, 2011 at 10:46 am
Hello,
Did you find your answer?
I'm still trying to find a solution that does not involve powershell.
Here is an article with powershell,
but in my case, not all servers allow me to use powershell.
thanks
October 6, 2011 at 12:59 pm
We use a VB script and xp_cmdshell. You have to get this from Windows one way or the other.
October 8, 2011 at 11:00 am
you can also use wmic as follows
wmic volume get label, "free space", name, capacity, "drive letter"
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply