SharePoint: Comment chercher les gros fichiers d’une web application avec SharePoint 2007 et 2010

 Tous les administrateurs de ferme ont le même soucis d’utilisation abusive des ressources disponibles.

Ainsi, il est régulier que les utilisateurs remontent des fichiers (image par exemple) ayant des résolutions allucinantes pour les présenter en vignette. Le fait est que ces fichiers prennent une place importante et peut entrainer d’autres soucis comme pour la saturation des quotas.

Je propose donc le script PowerShell suivant (qui fonctionne avec SharePoint 2007 et 2010)

[bool]$Verbose = $false

function Get-SPSite-Usage-Information([object]$TheSite)
{
    write-host "----------------------------------------------------- "
    write-host " Site Usage: ", $TheSite.Url
    $UsageInfo = $TheSite.Usage;

    [int]$MyDiscussionStorage = $UsageInfo.DiscussionStorage/(1024*1024)
    [int]$MyStorage = $UsageInfo.Storage/(1024*1024)
    [int]$MyBandwidth = $UsageInfo.Bandwidth/(1024*1024)
    write-host "   >>> Site DiscussionStorage: ", $MyDiscussionStorage, "MB"
    write-host "   >>> Site Storage: ", $MyStorage, "MB"
    write-host "   >>> Site Bandwidth: ", $MyBandwidth, "MB"
    write-host "   >>> Site Hits: ", $UsageInfo.Hits
    write-host "   >>> Site Visits: ", $UsageInfo.Visits

    write-host "----------------------------------------------------- "
}

function Get-SPSite-StoreManagement-Details([object]$TheSite, [string]$FileExtension, [double]$ExceededSize)
{
    [double]$MyFileSize = 0
    [string]$myFileName
    [string]$myFileCompleteURL
    [string]$MyFilterOption = "LeafName Like '%."+ $FileExtension +"' AND TotalSize > "+ [string]($ExceededSize*1024*1024)
    [string]$MySortOption = "TotalSize DESC"
    [System.Data.DataTable]$MyResultSetFiltered
    Write-Host "SiteURL", $TheSite.Url

# ltVar: What kind of storage management information to display
# List = 1
# DocumentLibrary = 2
# Document = 3
# sordVar: the direction in which the items are to be sorted
# Increasing = 0×10
# Decreasing = 0×11
# soVar: whether the items are sorted by size or by date
# Size=0
# Date = 1
# nMaxResults: the number of results to return

    $MyInformationType = [Microsoft.SharePoint.SPSite+StorageManagementInformationType]::Document
    $MysortOrder = [Microsoft.SharePoint.SPSite+StorageManagementSortOrder]::Decreasing
    $MySortOn = [Microsoft.SharePoint.SPSite+StorageManagementSortedOn]::Size
    [int]$MaxItems = 999999

    $SiteURLRoot = $TheSite.url.split("/")
   
    [System.Data.DataTable]$MyResultSet = $TheSite.StorageManagementInformation($MyInformationType, $MysortOrder, $MySortOn, $MaxItems)

    Write-Host "MyResultSet Count: ", $MyResultSet.Rows.Count
    $MyResultSetFiltered = $MyResultSet.Select($MyFilterOption, $MySortOption)
    Write-Host "MyResultSetFiltered Count: ", $MyResultSetFiltered.Count

    Write-Host " ----------------- "
    foreach($myRow in $MyResultSetFiltered)
    {
        if($verbose)
        {
            foreach($MyColumn in $MyResultSet.Columns)
            {
                Write-Host "      ->Column:", $MyColumn, " - Value:", $myRow[$MyColumn]
            }
        }

        $myFileName = [string]$myRow['LeafName']
        $MyFileSize = [int]$myRow['TotalSize']/(1024*1024)
        $myFileCompleteURL = $SiteURLRoot[0] + "//" + $SiteURLRoot[2] + "/" + [string]$myRow['Directory'] + "/" + $myFileName

        Write-Host " FileName:", $myFileName
        Write-Host " FileSize[MB]:", $MyFileSize
        Write-Host " File URL:", $myFileCompleteURL
        Write-Host " ----------------- "
    }    
    $MyResultSet.Dispose()
}

function Get-All-SPSite-StoreManagement([string]$WebAppURL, [string]$FileExtension, [double]$ExceededSize)
{
    [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint") > $null

    $Thesite = new-object Microsoft.SharePoint.SPSite($WebAppURL)
    Write-Host "WebApp Root URL", $Thesite.Url
    $oApp = $Thesite.WebApplication
   
    foreach ($MySite in $oApp.Sites)
    {
        #Write-Host "  Site URL", $MySite.Url
        Get-SPSite-Usage-Information $MySite
        Get-SPSite-StoreManagement-Details $MySite $FileExtension $ExceededSize
    }
    $Thesite.Dispose()
}

function StartProcess()
{
    # Create the stopwatch
    [System.Diagnostics.Stopwatch] $sw;
    $sw = New-Object System.Diagnostics.StopWatch
    $sw.Start()
    cls

    Get-All-SPSite-StoreManagement “http://mywebApplication” "jpg" 1 #Adapt the size Value as you need – 1MB and the extension you need to control
    $sw.Stop()
    # Write the compact output to the screen
    write-host "Time: ", $sw.Elapsed.ToString()
}

StartProcess

Il faudra adapter la requête avec l’extension voulue et la taille minimal à traquer. Ce script vous donnera alors un résultat tel que le suivant :

Vous y trouverez un résumé de l’utilisation du site (racine ou sous-site), et la liste des fichiers ayant l’extension recherchée (JPG) et dépassant la taille limite (1 MB).

---

Attention

Ce script ne fonctionne pas sous SharePoint 2013, car la méthode a été désactivée par Microsoft:

• SharePoint Space Monitor for 2013?
• SharePoint 2013 で SPSite.StorageManagementInformation メソッドが使用できない
• SharePoint 2013 で SPSite.StorageManagementInformation メソッドが使用できない
• SPSite.StorageManagementInformation method

En revanche, l’utilisation pour SharePoint 2010 et 2007 est totalement fonctionnelle.

---

Liens annexes

Un ensemble de pages qui proposent des informations sur les méthodes utilisées :

• SPSite.UsageInfo Structure
• SPSite.StorageManagementInformation Method
• Getting Size Matrices for Document Library, List Libraries, and Items in a SharePoint 2010 Site Collection Using PowerShell
• How to find out the storage space allocation details a site through code.
• SPSite.Usage.Storage And SPSite.StorageManagementInformation Are Returning Different Values
• Get SharePoint Library Size with PowerShell
• Checking Site sizes in SharePoint 2007 and 2010

Romelard Fabrice [MBA]