Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# script to check a folder and get all file size in subfolder

Posted on 2011-09-13
Medium Priority
570 Views
Hi,

I need a script to get all file size (MB) in a specific folder and all subfolder.

the script must export to a csv file the result with all information like this:

Folder,filename,size

thanks
0
Question by:cawasaki
• 3
• 3

LVL 4

Expert Comment

ID: 36528561
How about something like Get-DiskUsage by Joel Bennett
0

LVL 59

Expert Comment

ID: 36528932
Do you want just one total for the specified folder, or a line for each subfolder as well?

~bp
0

LVL 59

Accepted Solution

Bill Prew earned 2000 total points
ID: 36529069
Here's a starting place for you, save as a VBS and adjust the directory name at the top. It displays the results to the screen, but you can easily place into a file using redirection, as in:

cscript //nologo filesze.vbs > filesize.csv

sFolder = "c:\ee\temp"

Set oFS = WScript.CreateObject("Scripting.FileSystemObject")

ShowFolderDetails oFS.GetFolder(sFolder)

Sub ShowFolderDetails(oFolder)
For Each oFile in oFolder.Files
Wscript.echo oFolder.Path & "," & oFile.Name & "," & Round(oFile.Size / 1024 / 1024, 2)
Next
For Each oSubFolder In oFolder.Subfolders
ShowFolderDetails(oSubFolder)
Next
End Sub

~bp
0

Author Comment

ID: 36529147
i need one line by file :)
0

Author Comment

ID: 36529158
hi Fryguy,

your link of powershell function is cool, can you explain me how i can use it? how i can add this function?

thanks
0

LVL 59

Expert Comment

ID: 36529167
==> i need one line by file :)

Okay, that's what the VB script above does.

~bp
0

Author Closing Comment

ID: 36534993
thanks good its work perfectly
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Loops Section Overview
Screencast - Getting to Know the Pipeline
###### Suggested Courses
Course of the Month12 days, 14 hours left to enroll