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
7
Medium Priority
?
570 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 59

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 59

Accepted Solution

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

Open in new window

~bp
0
Lessons on Wi-Fi & Recommendations on KRACK

Simplicity and security can be a difficult  balance for any business to tackle. Join us on December 6th for a look at your company's biggest security gap. We will also address the most recent attack, "KRACK" and provide recommendations on how to secure your Wi-Fi network today!

 

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 59

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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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

971 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