Free Disk Space Report:

Whether its for daily checks or a for a once off report this handy little script allows you to connect to as many servers as you like, query all local drives, report the capacity of the drives and the free space available. It writes all this information to a snazzy HTML file that is saved on the local disk.

This is a vbs file and uses a servers.txt (keep the txt file in the same location as the script) file as a reference for each of the servers you wish to connect to. I’ve tested this on up to 30 servers at a time with flawless output. This script can be run as a schedueled task and accross psexec. Just one point to note, if it is being executed from a UNC path, map the drive first or it will fail to lookup servers.txt

I use this script as a daily check to check up on all the file servers and exchange servers in the morning.

Heres an example of the html file you are finished with.

Server Utilization Report

Server1 Drive Utilization


C: Size: 20,003 MB Free: 8,791 MB |||||||||||||||||||||||||||||||||||||||||||| 43.95% Free
E: Size: 10,000 MB Free: 3,715 MB ||||||||||||||||||||||||||||||||||||| 37.15% Free

Created 26/02/2008 12:14:12 by morgan_a

For the code, click more…

‘Andrew Morgan February 2008
‘connects to a device and lists all capacity & free space

Dim objService,objLocator
Dim objFSO, objOutFile,objFile1
Dim objNetwork

‘Get Date Vars
strMonth = Month(Date)
strDay = Day(Date)
strYear = Right(Year(Date),2)

On Error Resume Next

‘Location of HTML file that will be created (dont use network shares unless drive is mapped)
htmFile=”c:” & strMonth & “-” & strDay & “-” & strYear & “.htm”

‘Name of servers text file (must be kept in the same directory as the script)
serverlist=”servers.txt”

Const myGreen=”008000″
Const myRed=”FF0000″
Const myYellow=”FFD700″

set objNetwork=CreateObject(“wscript.network”)
Set objFSO=CreateObject(“Scripting.FileSystemObject”)
Set objOutFile=objFSO.CreateTextFile(htmFile)
Set objFile1=objFSO.OpenTextFile(serverlist,1)

‘Write Lead in of htm file
‘Change the next line to change the header
objOutfile.WriteLine “<HTML><HEAD><TITLE>Server Logical Drive Utilization</TITLE></HEAD>”
‘objOutfile.WriteLine “<BODY BGCOLOR=” & CHR(34) & “FFFFF” & CHR(34)& “>”
objOutfile.WriteLine “<BODY BGCOLOR=FFFFF>”
objOutfile.WriteLine “<H1>Server Utilization Report</H1></P>”

Do While objFile1.AtEndOfStream<>True
strServer=objFile1.ReadLine

If strServer<>”” Then
‘reinitialize
PerFree=””
Graph=””
Size=””
Free=””

objOutfile.WriteLine “<BR>” & UCASE(strServer) & ” Drive Utilization<BR><HR>”

‘Create locator
Set objLocator = CreateObject(“WbemScripting.SWbemLocator”)
If Err.Number then
objOutfile.WriteLine “Error ” & err.number & ” [0x” & CStr(Hex(Err.Number)) & “] occurred in creating a locator object.<BR>”
If Err.Description <> “” Then
objOutfile.WriteLine “Error description: ” & Err.Description & “.</p>”
End If
Err.Clear
End If

‘Connect to the namespace which is either local or remote
‘Uncomment next line for debugging
‘wscript.echo “Connecting to ” & “(“&strServer&”,rootcimv2)”

Set objService = objLocator.ConnectServer (strServer,”rootcimv2″)
ObjService.Security_.impersonationlevel = 3
If Err.Number then
objOutfile.WriteLine “Error ” & err.number & ” [0x” & CStr(Hex(Err.Number)) &”] occurred in connecting to server ” & UCASE(strServer) & “.<BR>”
objOutfile.WriteLine “Make sure you are using valid credentials that have administrative rights on this server.</P>”
If Err.Description <> “” Then
objOutfile.WriteLine “Error description: ” & Err.Description & “.</P>”
End If
Err.Clear
Else

objOutfile.WriteLine “<Table Border=0 CellPadding=5>”
For Each item In objService.InstancesOf(“Win32_LogicalDisk”)
If item.DriveType=3 Then ‘get local drives only
PerFree=FormatPercent(item.FreeSpace/item.Size,2)
Graph=FormatNumber((item.Freespace/1048576)/(item.Size/1048576),2)*100
Size=FormatNumber(item.Size/1048576,0) & ” MB”
Free=FormatNumber(item.FreeSpace/1048576,0) & ” MB”

objOutfile.WriteLine “<TR>”
objOutfile.WriteLine “<TD>” &item.DeviceID & ” </TD>”
objOutfile.WriteLine “<TD>Size: ” & Size & “</TD>”
objOutfile.WriteLine “<TD>Free: ” & Free & “</TD>”
objOutfile.WriteLine “<TD><B><Font Size=+1 Color=” & GraphColor(graph) & “>” & String(Graph,”|”) & “</Font></B></TD>”
objOutfile.WriteLine “<TD>” & PerFree & ” Free</TD></TR>”
End If
Next
objOutfile.WriteLine “</Table>”
End If
End If
Loop
objFile1.Close

objOutfile.WriteLine(“</P><Font Size=-1><B><I> Created ” & NOW & ” by ” & objNetwork.UserName & “</I></B></Font>”)
objOutfile.WriteLine(“</BODY></HTML>”)
objOutfile.Close
‘commented echo back
‘wscript.Echo VBCRLF & “See ” & htmfile & ” for results”
Function GraphColor(graph)
On Error Resume Next
If Graph > 30 Then
GraphColor=myGreen
Exit Function
End If
If Graph < 10 Then
GraphColor=myRed
Else
GraphColor=myYellow
End If
End Function
Sub CheckResponse(response)
If response=”” Then
wscript.Echo “You didn’t enter anything in the last input box or you cancelled the script.”
wscript.Quit
End If
End Sub

‘EOF

Related Posts

Viewing open files on a file server from powershel... So this is a situation you should all be aware of in an SBC / VDI environment, despite all warnings, you've redirected folders to your network drive a...
Monitoring Storage disk queue’s and IO with ... Here's one that used to bother me alot. The problem usually went as follows: "Your XenApp servers have very high disk queue's and IO" "What's causin...
The curious case of missing file shares on a Micro... I had a very unusual issue recently where, after a fail over one of my file cluster resources didn't publish all shares to the users. Some shares did ...

3 Comments About “Free Disk Space Report:

Leave a Reply