It's not possible to add the file size to the library column as I would have to open every possible folder and our hierarchy is crazy. We are not at our limit, however, I know that many users are uploading large attachments and not overriding with newer versions so we are using way more than we need. I know storage metrics shows total size, however, we still have to spend hours opening every single folder > subfolder > subfolder > subfolder then back etc. I checked the Audit Log Search but there isn't anything for Search. We do not use OneDrive client for this library as there are too many files to support it. There must be a way?

Hi luvsql You could also create a new View within the library, Save All Items as File Size.Then edit the properties of this new view to be as followsColumnsTick to display File SizeSortFirst sort by the column , change to File SizeChoose : Show items in descending orderFoldersShow all items without folders This view will then show your biggest files at the top of the list.To show files over a certain size, you would have to add a calculated column I think.

HI luvsql Great that it is workingThe following line is that one that will need to change #Get All Files of the library with size > 100MB $Files = Get-PnPListItem -List $List -PageSize 500 | Where {($_.FieldValues.FileLeafRef -like "*.*") -and ($_.FieldValues.SMTotalFileStreamSize/1MB -gt 100)} The # means comment out this line i.e. it tells the programming language to ignore this row So I suggest you change the script so it looks like this , removing the part after the -and statement #Get All Files of the library with size > 100MB #$Files = Get-PnPListItem -List $List -PageSize 500 | Where {($_.FieldValues.FileLeafRef -like "*.*") -and ($_.FieldValues.SMTotalFileStreamSize/1MB -gt 100)} #Get all files, of any size $Files = Get-PnPListItem -List $List -PageSize 500 | Where {($_.FieldValues.FileLeafRef -like "*.*") I can't see anything in the script which will limit it to just 2 folders deep.It may be that there are NO files larger than 100MB that exists in folders lower than 2 folders deep. Microsoft have some training about PowerShellhttps://docs.microsoft.com/en-us/powershell/sharepoint/sharepoint-online/connect-sharepoint-online?view=sharepoint-psas do a number of prominent SharePoint online authoritieshttps://www.google.co.nz/search?q=how+to+learn+powershell+for+sharepoint Everyone who does our kind of work, can get value out of knowing something about PowerShell, so I highly recommend learning a little about it. I prefer dealing with people and the social anthropology side of my job, but there are times when Powershell makes things possible that wouldn't be otherwise.

Hi Mercedes, In Site Settings > Storage Metrics you can see the size of each library and clicking through to folders to see where large folders are.

luvsql Have you considered using PowerShell scripts to harvest the information of interest? e.g. get a complete list of all documents and their properties in a document library.Another option is to look for a reporting tool. There are apps that provide this capability (e.g. https://www.slimapplications.com/wp-content/uploads/2020/07/Encrypted-Documents.jpg) plus more. For example, find encrypted documents, checked-out documents, documents with versions consuming storage space, ...Paul

Thank you all for the suggestions. I shall try them out. My experience with Powershell is copying and pasting existing scripts so not sure I could figure out how to do that.

How to find files over certain limit in SharePoint Library with hundreds of folders

15 Replies

Paul_HK_de_Jong
Iron Contributor
Jul 23, 2021
luvsql
Have you considered using PowerShell scripts to harvest the information of interest? e.g. get a complete list of all documents and their properties in a document library.
Another option is to look for a reporting tool. There are apps that provide this capability (e.g. https://www.slimapplications.com/wp-content/uploads/2020/07/Encrypted-Documents.jpg) plus more. For example, find encrypted documents, checked-out documents, documents with versions consuming storage space, ...
Paul
- luvsql
  Iron Contributor
  Jul 23, 2021
  Thank you all for the suggestions. I shall try them out. My experience with Powershell is copying and pasting existing scripts so not sure I could figure out how to do that.
Dorje-McKinnon
Iron Contributor
Jul 23, 2021
Hi luvsql
You could also create a new View within the library, Save All Items as File Size.
Then edit the properties of this new view to be as follows
Columns
Tick to display File Size
Sort
First sort by the column , change to File Size
Choose : Show items in descending order
Folders
Show all items without folders

This view will then show your biggest files at the top of the list.
To show files over a certain size, you would have to add a calculated column I think.
- luvsql
  Iron Contributor
  Jul 23, 2021
  Dorje-McKinnon I just get the "something went wrong" after saving the new view. I think we have too many files. Anytime I try and use that File Size column it craps out.
  - SteveKnutson
    MVP
    Jul 24, 2021
    This will happen if the view returns more than 5000 items. Try adding a filter to the view to reduce the number of results - https://support.microsoft.com/en-us/office/use-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4
SteveKnutson
MVP
Jul 23, 2021
Hi Mercedes,

In Site Settings > Storage Metrics you can see the size of each library and clicking through to folders to see where large folders are.

Forum Discussion

How to find files over certain limit in SharePoint Library with hundreds of folders

15 Replies

Resources