Get All Files From SharePointLib To Excel - PowerShell

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

    Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$timestamp = get-date -format "yyyyMMdd_hhmmtt"

$filenameStart = "SharepointLibFileReport"

$logfile = ("{0}{1}.csv" -f $filenamestart, $timestamp)

$header = "$("SharePoint FileName") `t$("File KB Size") `t$("File MB Size") `t$("SharePoint FilePath") `t$("Count")"

$header | out-file -FilePath $logfile

# Get all files from drive

$dirfiles = gci -Recurse $localFolderPath | select  name,Attributes,FullName,length | sort parent

$web = Get-SPWeb http://win-2016

$list = $web.Lists["Documents"]

$spQuery = New-Object Microsoft.SharePoint.SPQuery;

$spQuery.ViewAttributes = "Scope='RecursiveAll'";

$spQuery.Query = '<OrderBy><FieldRef Name="ID" Ascending="True" /></OrderBy>'

$spListItems = $list.GetItems($spQuery)

$count=0;

$suffix = "B", "KB", "MB", "GB", "TB", "PB", "EB", "ZB", "YB"

$index = 0

foreach ($item in $spListItems)

{

$count++;

#To Calculate Total Size(MB)

$fileKBSize =  [Math]::Round(($item.File.Length/1KB),1);

$fileMBSize =  [Math]::Round(($item.File.Length/1MB),1);

write-host "file Name(Migrated) :" $item.Name "KB Length :" $fileKBSize "MB Length :"$fileMBSize  -ForegroundColor Green

$header = "$($item.Name) `t$($fileKBSize) `t$($fileMBSize) `t$($web.Url+"/"+$item.Url) `t$($count)"

$header | out-file -FilePath $logfile  -append

}

Get All File And Folder Details to Excel - PowerShell

Step 1: Save GetAllFileAndFolderFromDrive.PS1 below script
Step 2: Change the file Path.
Step 3: Save .bat(After script below line)  and execute run with admin

if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

    Add-PSSnapin "Microsoft.SharePoint.PowerShell"

}

$timestamp = get-date -format "yyyyMMdd_hhmmtt"

$filenameStart = "ReportFilesFolder"

$logfile = ("{0}{1}.csv" -f $filenamestart, $timestamp)

$header = "$("Drive FileName") `t$("Drive FileSize") `t$("Drive/File") `t$("Drive FilePath") "

$header | out-file -FilePath $logfile

$localFolderPath = "D:\TestingFolder"

$count=0

$dirfiles = gci -Recurse $localFolderPath | select  name,Attributes,FullName,length | sort parent

$fileCount=0

$dirCount=0

$dfilesize="";

function ProcessFolder {

        ForEach($dfile in $dirfiles)

            {

                  if ($dfile.Attributes -ne "Directory")

                    { 

                     $count++;    

                     # working in files

                     $dfilesize= DisplayInBytes(($dfile).length);

                     write-host "file : " $dfile.FullName,"file size: " $dfilesize ,$count

                     $header = "$($dfile.Name) `t$($dfilesize) `t$('File') `t$($dfile.FullName) "

                     $header | out-file -FilePath $logfile  -append

                  }

                  else{

                  $dirCount++;

                  #Directory

                  write-host "folder : " $dfile.FullName ,$dirCount

                  $header = "$($dfile.Name) `t$('') `t$('Directory') `t$($dfile.FullName) "

                  $header | out-file -FilePath $logfile  -append

                  }

                

            }

         write-host "Total file's count : " ,$count,"  Total folder's count : "$dirCount

}

function DisplayInBytes($num)

{

    $suffix = "B", "KB", "MB", "GB", "TB", "PB", "EB", "ZB", "YB"

    $index = 0

    while ($num -gt 1kb)

    {

        $num = $num / 1kb

        $index++

    }

    "{0:N} {1}" -f $num, $suffix[$index]

}

#Download root files

ProcessFolder('')

#Download files in folders

---------------------------------------

cd /d %~dp0

powershell -noexit -file "GetAllFileAndFolderFromDrive.PS1" "%CD%"

pause

PowerShell Script: Find the largest files and folders for any drive

######################################################################

#

# This script will find the 10 (default) largest files and then list the

# folders sizes of the c:\ drive (default). The results will be written to a

# formatted text file. At the end of the script is an option to scan and list

# the size of all sub folders within a particular folder, output will be

# appended to the txt file generated during the initial scan.

######################################################################

# Modify these 3 variables as needed

# Output file location and name

$findFilesFoldersOutput = "C:\FindLargestFilesAndFolders.txt";

# Drive to Scan

$diskDrive = "C:"

# Limit number of rows on output, top XX files

$filesLimit = 10;

###################################

# Do not edit below!

###################################

# Misc settings

# Root location to scan for folder size

$filesLocation = "$diskDrive\";

$rootLocation = $filesLocation;

# Set output width

$outputWidth = 150;

# Minimum file size

$fileSize = 10MB;

# Search for specific file extensions - Default *.*

$extension = "*.*";

# Time stamp

$Time = Get-Date -format "dd-MMM-yyyy-HH-mm"

###################################

# Scan Drive for capacity and free space

###################################

Function driveScan {

$disk = Get-WmiObject Win32_LogicalDisk -Filter "DeviceID='$diskDrive'" | Select-Object Size,FreeSpace

$total = "{0:N0}" -f ($disk.Size / 1GB) + " GB"

$free = "{0:N0}" -f ($disk.FreeSpace / 1GB) + " GB"

$freeMB = "{0:N0}" -f ($disk.FreeSpace / 1MB) + " MB"

Write-Host " "

write-host "Total capacity of $diskDrive - $total"

write-host "Total space free on $diskDrive - $free / $freeMb"

" " | out-file $findFilesFoldersOutput -append

"Total capacity of $diskDrive - $total" | out-file $findFilesFoldersOutput -append

"Total space free on $diskDrive - $free / $freeMb" | out-file $findFilesFoldersOutput -append

" " | out-file $findFilesFoldersOutput -append

" " | out-file $findFilesFoldersOutput -append

}  

###################################

# Top Largest Files Scan

###################################

Function fileScan {

Write-Host " "

Write-Host "Scanning $filesLocation for the $filesLimit largest files, this process will take a few minutes..."

"Below are the $filesLimit largest files on $filesLocation from largest to smallest:" | out-file -width $outputWidth $findFilesFoldersOutput -append

$largeSizefiles = get-ChildItem -path $filesLocation -include $Extension -recurse -ErrorAction "SilentlyContinue" | ? { $_.GetType().Name -eq "FileInfo" } | where-Object {$_.Length -gt $fileSize} | sort-Object -property length -Descending | Select-Object Name, @{Name="Size In MB";Expression={ "{0:N0}" -f ($_.Length / 1MB)}},@{Name="LastWriteTime";Expression={$_.LastWriteTime}},@{Name="Path";Expression={$_.directory}} -first $filesLimit

$largeSizefiles | format-list -property Name,"Size In MB",Path,LastWriteTime | out-file -width $outputWidth $findFilesFoldersOutput -append

Write-Host " "

Write-Host "File Scan Complete..."

Write-Host " "

}

###################################

# Top Largest Folders Scan

###################################

Function folderScan {

$subDirectories = Get-ChildItem $rootLocation | Where-Object{($_.PSIsContainer)} | foreach-object{$_.Name}

Write-Host "Calculating folder sizes for $rootLocation,"

Write-Host "this process will take a few minutes..."

"Estimated subfolder sizes for $rootLocation :" | out-file -width $outputWidth $findFilesFoldersOutput -append

Write-Host " "

" "  | out-file -width $outputWidth $findFilesFoldersOutput -append

$folderOutputFixed = @{}

foreach ($i in $subDirectories)

       {

       $targetDir = $rootLocation + $i

       $folderSize = (Get-ChildItem $targetDir -Recurse -Force | Measure-Object -Property Length -Sum).Sum 2> $null

    $folderSizeComplete = "{0:N0}" -f ($folderSize / 1MB) + "MB"

       $folderOutputFixed.Add("$targetDir" , "$folderSizeComplete")

       write-host " Calculating $targetDir..."

}

$folderOutputFixed.GetEnumerator() | sort-Object Name | format-table -autosize | out-file -width $outputWidth $findFilesFoldersOutput -append

Write-Host " "

Write-Host "Attempting to open scan results with notepad..."

c:\windows\system32\notepad.exe "$findFilesFoldersOutput"

Write-Host " "

Write-Host "Scan saved to: $findFilesFoldersOutput..."

Write-Host " "

}

###################################

# Custom Folder Scan

###################################

Function customScan {

Write-Host " "

write-host "Would you like to scan a specific directory for subfolder sizes?"

write-host "Ex C:\, C:\Windows"

write-host " "

write-host "Press CTRL + C to exit at any time."

write-host " "

$customLocation= Read-Host 'Please enter directory path here'

$subDirectories = Get-ChildItem $customLocation | Where-Object{($_.PSIsContainer)} | foreach-object{$_.Name}

Write-Host " "

Write-Host "Calculating folder sizes for $customLocation,"

Write-Host "this process will take a few minutes..."

" "  | out-file -width $outputWidth $findFilesFoldersOutput -append

"Estimated folder sizes for $customLocation :" | out-file -width $outputWidth $findFilesFoldersOutput -append

Write-Host " "

" "  | out-file -width $outputWidth $findFilesFoldersOutput -append

$folderOutput = @{}

foreach ($i in $subDirectories)

       {

       $targetDir = $customLocation + "\" + $i

       $folderSize = (Get-ChildItem $targetDir -Recurse -Force | Measure-Object -Property Length -Sum).Sum 2> $null

    $folderSizeComplete = "{0:N0}" -f ($folderSize / 1MB) + "MB"

       $folderOutput.Add("$targetDir" , "$folderSizeComplete")

    write-host " Calculating $targetDir..."

}

$folderOutput.GetEnumerator() | sort-Object Name | format-table -autosize | out-file -width $outputWidth $findFilesFoldersOutput -append

Write-Host " "

Write-Host "Attempting to open scan results with notepad..."

c:\windows\system32\notepad.exe "$findFilesFoldersOutput"

Write-Host " "

Write-Host "Scan saved to: $findFilesFoldersOutput..."

Write-Host " "

customScan

}

# Pause

Function Pause {

Write-Host -NoNewLine "Press any key to continue..."

$null = $Host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")

}

# Clear the screen

clear

# Clear the output file if it exists by writing a timestamp

$time | out-file -width $outputWidth $findFilesFoldersOutput

# Execute the functions

# Comment out any of the below functions to prevent them from running

driveScan

fileScan

folderScan

customScan

Reference : http://robwillis.info/2014/07/powershell-script-find-the-25-largest-files-and-list-folder-sizes-for-any-drive/