Solved

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

Posted on 2011-09-13
549 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 51

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 51

Accepted Solution

Bill Prew earned 500 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 51

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

The article will show you how you can maintain a simple logfile of all Startup and Shutdown events on Windows servers and desktops with PowerShell. The script can be easily adapted into doing more like gracefully silencing/updating your monitoring s…
Create and license users in Office 365 in bulk based on a CSV file. A step-by-step guide with PowerShell script examples.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…