Get Total Count of SharePoint Files, Folders, and Items with PnP PowerShell

GetfilefolderItemcountTenant

#Parameters
$SiteURL="https://contosoonline-admin.sharepoint.com/"

$dateTime = (Get-Date).toString("dd-MM-yyyy")
$invocation = (Get-Variable MyInvocation).Value
$directorypath = Split-Path $invocation.MyCommand.Path
$fileName = "SiteStats-" + $dateTime + ".csv"
$OutPutView = $directorypath + "\Logs\"+ $fileName
$Excludedsites =@("https://contosoonline.sharepoint.com/sites/ACT-TrunkDemo-OpenAccess","https://contosoonline.sharepoint.com/teams/TrunkDemo","https://contosoonline.sharepoint.com/sites/Test-OpenAccess"
,"https://contosoonline.sharepoint.com/teams/Test1","https://contosoonline.sharepoint.com/sites/d-intranet",
 "https://contosoonline.sharepoint.com/sites/d-intranet-aboutus","https://contosoonline.sharepoint.com/sites/d-intranet-community", "https://contosoonline.sharepoint.com/sites/d-intranet-directorate",
 "https://contosoonline.sharepoint.com/sites/d-intranet-directorate-comms","https://contosoonline.sharepoint.com/sites/d-intranet-employeehub", "https://contosoonline.sharepoint.com/sites/d-intranet-news","https://contosoonline.sharepoint.com/teams/d-app-caspr-portal","https://contosoonline.sharepoint.com/teams/d-app-app");

$global:foldercounter = 0 
$global:fileCounter = 0 
$global:ItemCounter = 0 
$SiteStats= @()
#Delete the Output Report, if exists
If (Test-Path $OutPutView) { Remove-Item $OutPutView }
Start-Transcript

    #Connect to the Site       
    Connect-PnPOnline -Url $SiteURL -Interactive
    $adminconnection = Get-PnPConnection
    #Array to Skip System Lists and Libraries
    $SystemLists = @("Converted Forms", "Master Page Gallery", "Customized Reports", "Form Templates", "List Template Gallery", "Theme Gallery","Apps for SharePoint",
    "Reporting Templates", "Solution Gallery", "Style Library", "Web Part Gallery","Site Assets", "wfpub", "Site Pages", "Images", "MicroFeed","Pages")
    #Get All Site collections - Exclude: Seach Center, Redirect site, Mysite Host, App Catalog, Content Type Hub, eDiscovery and Bot Sites
    $m365Sites = Get-PnPTenantSite | Where-Object -Property Url -NotIn $Excludedsites  | Where-Object -Property Template -NotIn ("PWA#0","SRCHCEN#0", "REDIRECTSITE#0", "SPSMSITEHOST#0", "APPCATALOG#0", "POINTPUBLISHINGHUB#0", "POINTPUBLISHINGTOPIC#0","EDISC#0", "STS#-1") 
    #($_.Url -like '*/TEAM-*' -or  $_.Url -like '*/ACT-*' -or  $_.Url -like '*/PROJ-*' -or $_.Template -eq 'TEAMCHANNEL#1') -and
    #$m365Sites = Get-PnPTenantSite -Detailed | Where-Object {($_.Url -like '*Comm*') -and $_.Template -ne 'RedirectSite#0' }
    $m365Sites | ForEach-Object {
        Write-host -f Yellow "Scanning site:" $_.Url " Template" $_.Template
        $siteFolderCount = 0;
        $siteFileCount = 0;
        $siteItemCount = 0;
    Try{
        $siteUrl = $_.Url;     
        Connect-PnPOnline -Url $siteUrl -Interactive
        $siteconnection = Get-PnPConnection
                #Get All Lists
        $Lists = Get-PnPList -Includes RootFolder -connection $siteconnection| Where-Object {$_.Hidden -eq $False  }
        #-and $SystemLists -notcontains $_.Title -and $_.BaseTemplate -eq 101
        #Get content types of each list from the web
        
        ForEach($List in $Lists)
        {
            $ListURL =  $List.RootFolder.ServerRelativeUrl

            $folders = Get-PnPListItem -List "$($List.Title)" -PageSize 500 -connection $siteconnection -ScriptBlock `
                { Param($items) $global:counter += $items.Count;} `
                | Where-Object {$_.FileSystemObjectType -eq "Folder"}
            $filesItems = Get-PnPListItem -List "$($List.Title)" -PageSize 500 -connection $siteconnection -ScriptBlock `
                { Param($items) $global:counter += $items.Count;} `
            | Where-Object {$_.FileSystemObjectType -ne "Folder"}
            
            $global:folderCounter += $folders.Count
            $siteFolderCount+=$folders.Count
            if($List.BaseTemplate -eq 101){
              $global:fileCounter += $filesItems.Count
              $siteFileCount +=$filesItems.Count
            }
            else {
               $global:ItemCounter += $filesItems.Count
               $siteItemCount += $filesItems.Count
            }
        }
        $TotalFileCount = Get-PnPFolderStorageMetric -FolderSiteRelativeUrl $siteurl -connection $siteconnection| Select -ExpandProperty TotalFileCount  
        #Collect data
        $Data = [PSCustomObject][ordered]@{
            SiteURL  = $siteUrl
            FilesCount = $siteFileCount
            FolderCount = $siteFolderCount
            ItemCount = $siteItemCount
            SiteFileCount = $TotalFileCount #includes checked out files 
        }
        $SiteStats+= $Data
  }

  Catch {
    write-host -f Red "Error Generating Stats Report!" $_.Exception.Message
  }
  $Data = [PSCustomObject][ordered]@{
    SiteURL  = "tenant"
    FilesCount = $global:filecounter
    FolderCount = $global:foldercounter
    ItemCount = $global:itemcounter
    SiteFileCount = ($global:filecounter + $global:itemcounter)#excludes checked out files  
}
}

$FolderStats | Export-Csv -Path $OutPutView -NoTypeInformation

Stop-Transcript