Solved

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

Posted on 2011-09-13
7
549 Views
Last Modified: 2012-05-12
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
Comment
Question by:cawasaki
  • 3
  • 3
7 Comments
 
LVL 4

Expert Comment

by:Ryan Weaver
ID: 36528561
How about something like Get-DiskUsage by Joel Bennett
0
 
LVL 51

Expert Comment

by:Bill Prew
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

by:
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

Open in new window

~bp
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

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

Author Comment

by:cawasaki
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

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

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

~bp
0
 

Author Closing Comment

by:cawasaki
ID: 36534993
thanks good its work perfectly
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now