Ask the Community
Groups
Troubleshooting: List/Sort files by size - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>QUESTION:</strong><br>How do I list the top X (10, 20, etc.) files by size (largest down - descending order)?</p> <p><strong>CAUSE:</strong><br>Your system may be running out of disk space and you may want to identify the largest files on the system</p> <p><strong>SOLUTION:</strong></p> <p><strong>Tip: We recommend that you build two lists two hours apart so that the results may be compared</strong></p> <p><strong>NOTE:</strong> <br>- Replace TRAVERSE_HOME with the Traverse installation directory on your system<br>- Make sure the long command below is all typed in one line<br>- The example below lists the top 20 files by descending size (select -first 20)</p> <p>Open a DOS command prompt using 'Run As Administrator' and launch powershell<br><br>C:\Windows\system32>powershell<br>PS C:\Windows\system32> $FormatEnumerationLimit=-1<br><br>PS C:\Windows\system32>cd TRAVERSE_HOME<br>PS C:\Program Files (x86)\Traverse> Get-ChildItem -Path . -Recurse -Force | Where-Object { !$_.PSIsContainer } | Select-Object -Property FullName,@{Name='SizeGB<br>';Expression={$_.Length / 1GB}} | Sort-Object { $_.SizeGB } -Desc| select -first 20 | Out-String -Width 240</p> <p>FullName<br> SizeGB<br>--------<br> ------<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\messages.MYD<br> 6.44907046109438<br>C:\Program Files (x86)\Traverse\database\backup\backup_aggregateddatadb\messages.MYD<br> 6.44785480573773<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\messages.MYI<br> 1.87986183166504<br>C:\Program Files (x86)\Traverse\bin\hs_err_pid2044.mdmp<br> 1.38238046877086<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme2.MYD<br> 1.31448789127171<br>C:\Program Files (x86)\Traverse\database\backup\backup_aggregateddatadb\aggregationdatascheme2.MYD<br> 1.31448789127171<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\userevent.MYI<br> 0.82502269744873<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\userevent.MYD<br> 0.82455737143755<br>C:\Program Files (x86)\Traverse\database\backup\backup_aggregateddatadb\userevent.MYD<br> 0.82455737143755<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme2.MYI<br> 0.509856224060059<br>C:\Program Files (x86)\Traverse\database\backup\backup_aggregateddatadb\aggregationdatascheme1.MYD<br> 0.501284742727876<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme1.MYD<br> 0.501284742727876<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme0.MYD<br> 0.222308347932994<br>C:\Program Files (x86)\Traverse\database\backup\backup_aggregateddatadb\aggregationdatascheme0.MYD<br> 0.222308347932994<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme1.MYI<br> 0.187067031860352<br>C:\Program Files (x86)\Traverse\database\backup\backup_aggregateddatadb\aggregationdatascheme3.MYD<br> 0.142579710111022<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme3.MYD<br> 0.142579710111022<br>C:\Program Files (x86)\Traverse\uninstall\.com.zerog.registry.xml<br> 0.101473740302026<br>C:\Program Files (x86)\Traverse\01-OLD_VERSION\database\export.xml<br> 0.0990461139008403<br>C:\Program Files (x86)\Traverse\database\mysql\aggregateddatadb\aggregationdatascheme0.MYI<br> 0.0825843811035156</p> <p> </p> <p><strong>REFERENCES:</strong><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fstackoverflow.com%2Fquestions%2F798040%2Ffind-the-10-largest-files-within-a-directory-structure"> find the 10 largest files within a directory structure</a><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fblog.danskingdom.com%2Ffind-largest-or-smallest-files-in-a-directory-or-drive-with-powershell%2F"><br>Find Largest (Or Smallest) Files In A Directory Or Drive With PowerShell<br></a><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fgreiginsydney.com%2Fviewing-truncated-powershell-output%2F">Viewing Truncated PowerShell Output</a></p> </article> </main>