Generate version size report

最新推荐文章于 2025-08-01 14:01:10 发布

yamor

最新推荐文章于 2025-08-01 14:01:10 发布

阅读量600

点赞数

CC 4.0 BY-SA版权

分类专栏： sharepoint powershell

本文链接：https://blog.youkuaiyun.com/yamor/article/details/9386243

sharepoint 同时被 2 个专栏收录

18 篇文章

订阅专栏

powershell

5 篇文章

订阅专栏

本文提供了一个 PowerShell 脚本，用于计算 SharePoint 站点集合中所有子站点的文件大小，包括各个版本的大小。脚本遍历每个站点、网站集和文档库，收集并记录关键信息，最终生成详细的 CSV 报告。

#==================================================
# Get Size of all Sub-sites in a Site Collection
#==================================================

Add-PsSnapin Microsoft.SharePoint.Powershell –ErrorAction SilentlyContinue
Clear-Host

#Define Web Application
$WebAppURL = "http://"

Function GenerateVersionSizeReport()
{

#Get the Web Application
$WebApp=Get-SPWebApplication($WebAppURL)

#Write the CSV Header - Tab Separated
"Site Name`t Library `t File Name `t File URL `t File Type `t Last Modified `t No. of Versions `t Latest Version Size(MB) `t Versions Size(MB) `t Total File Size(MB)" | out-file VersionSizeReport.csv

#Loop through each site collection
foreach($Site in $WebApp.Sites)
   {
    #Loop through each site in the site collection
     foreach($Web in $Site.AllWebs)
   {
            #Loop through each List
            foreach ($List in $Web.Lists)
            {
                #Get only Document Libraries & Exclude Hidden System libraries
                if ( ($List.BaseType -eq "DocumentLibrary") -and ($List.Hidden -eq $false) )
                {
                    foreach ($ListItem in $List.Items)
                    {
          #Consider items with 1+ versions
                        if ($ListItem.Versions.Count -gt 1)
                        {
          $versionSize=0

                            #Get the versioning details
                            foreach ($FileVersion in $ListItem.File.Versions)
                            {
                                $versionSize = $versionSize + $FileVersion.Size;
                            }
       #To Calculate Total Size(MB)
       $ToalFileSize= [Math]::Round(((($ListItem.File.Length + $versionSize)/1024)/1024),2)

                            #Convert Size to MB
                            $VersionSize= [Math]::Round((($versionSize/1024)/1024),2)

       #Get the Size of the current version
       $CurrentVersionSize= [Math]::Round((($ListItem.File.Length/1024)/1024),2)

                            #Get Site Name
                            if ($Web.IsRootWeb -eq $true)
                            {
                                $siteName = $Web.Title +" - Root";
                            }
                            else
                            {
                                $siteName= $Site.RootWeb.Title + " - " + $Web.Title;
                            }

                            #Log the data to a CSV file where versioning size > 0MB!
                            if ($versionSize -gt 0)
                            {
                                "$($siteName) `t $($List.Title) `t $($ListItem.Name) `t $($Web.Url)/$($ListItem.Url) `t $($ListItem['File Type'].ToString()) `t $($ListItem['Modified'].ToString())`t $($ListItem.Versions.Count) `t $CurrentVersionSize `t $($versionSize) `t $($ToalFileSize)" | Out-File VersionSizeReport.csv -Append
                            }
                        }
                    }
                }
            }
  $Web.Dispose()
        }
$Site.Dispose()
    }

    #Send message to console
    write-host "Versioning Report Generated Successfully!"
}