Jeff Moden (9/3/2014)
JimAtWork (2/3/2014)
I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ and also do not allow the use of Powershell for security reasons. Any work-arounds for that? TIASorry for the late reply but, Yes... DOS batch code with calls to WMI.
Attached is an old vb script that checks free space percentage. It uses Win32_PerfFormattedData_PerfDisk_LogicalDisk WMI class. You probably want to use the Win32_LogicalDisk class.
This was used to send back free space to a centralized monitoring system. The comments should point you in the right direction.
You will need to change the extension to .vbs
Hope this helps.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/