SharePoint storage report in Microsoft 365

Does this script give number of version of the files or the file size which is total of all the version it has.

I've checked it gives only current version of fileand not the total size of version as it shows in storage metrics 

pngit 

To view a SharePoint storage report in Microsoft 365, you can follow these steps:

1. Go to the Microsoft 365 admin center (https://admin.microsoft.com) and sign in with your admin credentials.

2. In the left navigation menu, click on "Reports."

3. In the "Reports" section, click on "Usage."

4. In the "Usage" section, click on "SharePoint."

5. This will take you to the SharePoint usage report, which shows you a breakdown of storage usage for each SharePoint site in your organization. You can view the report by day, week, month, or year, and you can filter the report by site, user, or file type.

6. To export the report, click on the "Export" button in the upper-right corner of the report and select your desired format (CSV or XLSX).

Note that you must have the necessary permissions to view the SharePoint usage report. Specifically, you must be a global or SharePoint admin, or you must have the "View usage data" permission for the SharePoint site you want to view the report for.

Hi pngit, 

You can get the partial information from M365 Admin Center > Reports > Usage section as shown below:

This section will help you understand the sites which have more number of inactive files. However, this section will not show those exact file listings.

pngit 

Yes and No,
You can see what sites are take the most storage but not anything else from admin portal.
What you can do is to get iterate through the each site and check the document libraries for files, the main issue here is version management. So 1gb file with 100 versions will be 100gb's.

You can modify this script, what you need to add it get get all sites, all document libraries in the site and add versioning:

#Set Variables
$SiteURL = ""
$LibraryName = "Documents"
$ReportOutput = "C:\Temp\getAllFiles.csv"
#Connect to SharePoint Online site
Connect-PnPOnline -Url $SiteURL -Interactive
 
$FileData = @()
#Iterate through all files
$ItemCounter = 0 


$ListItems = Get-PnPListItem -List $LibraryName -PageSize 500 -Fields Author, Editor, Created, File_x0020_Type, File_x0020_Size, Versions

Foreach ($Item in $ListItems)
{

            $FileData += New-Object PSObject -Property ([ordered]@{
            Name              = $Item["FileLeafRef"]
            Type              = $Item.FileSystemObjectType
            FileType          = $Item["File_x0020_Type"]
            FileSize =  [Math]::Round(($Item.FieldValues.File_x0020_Size/1KB),2)
            RelativeURL       = $Item["FileRef"]
            CreatedByEmail    = $Item["Author"].Email
            CreatedOn         = $Item["Created"]
            Modified          = $Item["Modified"]
            ModifiedByEmail   = $Item["Editor"].Email
        })
}

$FileData | Export-Csv -Path $ReportOutput -NoTypeInformation -Delimiter ";"