Wednesday, 11 July 2018

SharePoint 2013: Get the sites which are not modified since 90 days


if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null)
{
    Add-PSSnapin "Microsoft.SharePoint.PowerShell"
    Get-PSSnapin -Registered
 
}

    $webApp = Get-SPWebApplication $siteUrl
    $daysInActive = Read-Host "Enter in number of days to check since last modified"
    $date = (Get-Date).AddDays(-$daysInActive).ToString(“MM/dd/yyyy”)


    $SiteDetail = @();
   
    foreach ($web in $webApp | Get-SPSite -Limit All | Get-SPWeb -Limit All)
    {   
        if ($web.LastItemModifiedDate -le $date)
        {

             $row = new-object PSObject
               # Add-member -inputObject $row -memberType NoteProperty -Name "Title" -value $web.Title
                Add-member -inputObject $row -memberType NoteProperty -Name "Site Name" -value $web.Name
                Add-member -inputObject $row -memberType NoteProperty -Name "URL" -value $web.Url
                Add-member -inputObject $row -memberType NoteProperty -Name "Last Modified Date" -value $web.LastItemModifiedDate
                Add-Member -InputObject $row -MemberType NoteProperty -Name "Site Owners" -value $web.site.Owner
                Add-Member -InputObject $row -MemberType NoteProperty -Name "Owners Email" -value $web.site.Owner.Email
                Add-Member -InputObject $row -MemberType NoteProperty -Name "Size in GB" -value $web.site.Usage.Storage
                Add-Member -InputObject $row -MemberType NoteProperty -Name "User Hits" -value $web.Usage.Hits
                Add-Member -InputObject $row -MemberType NoteProperty -Name "All Users" -value $web.AllUsers.Count
               
               
                $SiteDetail += $row;
              
        }
       
    }
    $SiteDetail
    $sitedetail | Export-Csv -Path "C:\Tempsc\Sites.csv"
    






No comments:

Post a Comment