November 9, 2009 at 7:03 am
can any one send me the script of how to fnid the disk report of used , total size and avaialble space on all drives on a server ?
November 9, 2009 at 7:21 am
Sorry I dont have one atm, maybe someone less busy will have time to find one for you.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 9, 2009 at 3:09 pm
November 9, 2009 at 3:54 pm
the script repository here at SSC also has some scripts that would be of use. Check those out too. Download a few and find the one you like best.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 9, 2009 at 11:29 pm
Hi,
Stored below code in .VBS file & run file
You can change parameter (Disk.FreeSpace/Disk.Size) < 0.30 in script
Set DiskSet = GetObject("winmgmts:{impersonationLevel=impersonate}").ExecQuery("select FreeSpace,Size,Name from Win32_LogicalDisk where DriveType=3")
for each Disk in DiskSet
If (Disk.FreeSpace/Disk.Size) < 0.30 Then
WScript.Echo "Drive " + Disk.Name + " Total Size = " + Disk.Size + " The Free Space = " + Disk.FreeSpace + " MB"
End If
Next
Regards,
Deepali
November 9, 2009 at 11:36 pm
I used Google. Found http://www.sqlservercentral.com/Forums/Topic113227-5-1.aspx which contains a script to do what you ask. The people in the thread seemed impressed with it.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply