Need a vb script to get folder sizes for many projects on server.

Need a vb script to get folder sizes for many projects on server. Need it to loop through the csv file for folder locations and them produce a csv file with the folder location and the folder size.
Who is Participating?
MacroShadowConnect With a Mentor Commented:
' NAME: folderSize.vbs
' COMMENT: Scans folder sizes of a selected folder.
Dim objFSO, objFolder, objFile, objFile2, F, myVar1, myVar2, folderCount, strWrite

folderCount = 0
objFile2 = "folderdetails.csv"

Set objFSO = WScript.CreateObject("Scripting.FileSystemObject")
Call browseFolder(strFolderSrc,"Source")
Set objFolder = objFSO.GetFolder(strFolderSrc)

'Write Header Row
Set objFile = CreateObject("Scripting.FileSystemObject")   
Set strWrite = objFile.OpenTextFile(objFile2, 2, True)
strWrite.WriteLine("Folder Name,Size (MB),# Files,# Sub Folders")
Wscript.Sleep 300

ShowFolderDetails objFolder


MsgBox "Complete."

Set objFSO = Nothing
Set objFolder = Nothing
Set objFile = Nothing
Set objFile2 = Nothing
Set F = Nothing
Set myVar1 = Nothing
Set myVar2 = Nothing
Set strWrite = Nothing

Function ShowFolderDetails(oF)
    strWrite.WriteLine(oF.Name + "," + CStr(oF.Size /1024\1024) + "," + CStr(oF.Files.Count) + "," + CStr(oF.Subfolders.Count))

    'Comment out the following line and the loop to end the statement
    'to list all subfolders.(End Loop is 6 lines down)
    Do While folderCount < 1
    	for each F in oF.Subfolders
        	ShowFolderDetails F
    	folderCount = folderCount + 1
End Function

' browseFolder brings up the selection box to choose both the source and the destination.
Function browseFolder(myVar1,myVar2)
	Const NO_OPTIONS = 0
	Set objShell = CreateObject("Shell.Application")
	Set objFolder = objShell.BrowseForFolder _
    	(WINDOW_HANDLE, "Select a " & myVar2 & " folder:", NO_OPTIONS, "C:\Scripts")
	On Error Resume Next
	Set objFolderItem = objFolder.Self
	objPath = objFolderItem.Path
	myVar1 = objPath
	Call objPathChk(myVar1)
End Function

' objPathChk checks to make sure that a source has been selected.
Function objPathChk(myVar1)
	If myVar1 = "" Then
		MsgBox "Scan Folder Not Specified." & VbCrLf & _
				"Scan will now quit.", vbOKOnly, "Terminate"
	End If		
End Function

Open in new window
Scott ThomsonCommented:
do you want just the main directory and all subdirectories tallies as 1 result

- Gold
 - Real Gold
   - Really bright

Would you like the total size of Gold and all subdirectories
Or would you like each folder tallied individually?
williamflAuthor Commented:
The good news we pull the folder locations from a database.  So we have the folder direct share locations. So we would like to just do direct targeted folder locations. We are just want get the actual folder size for the trgeted folder. (//testfolder/project1)
The problem we are trying to resolve is we have 1000’s of project folders that grow intermittently some even out of control. The folders are part of an applications repository.  So this is not a traditional file store with independent security. The application governs everything.
If we use traditional tools like site scope directory monitors is scans to much information and can days on the folder with millions of files just to get total. If I use a simple VB script just ot get only folder size it just takes minutes.  We are planning creating a custom sitescope monitor to just get folder size but until then then just use a basic vbscript to get data for now.

I will try to the above suggestion.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.