SharePoint 2019 inactive sites report

Hi Mike9323,

the script you've provided is a good starting point, but it lacks the specific logic to determine site inactivity.

Below is the example PowerShell script (i haven't be able to test it) that hase more "advanced" criteria for identifying potentially inactive sites based on a combination of factors. You will need to customize the script to match your organization's needs and criteria for site inactivity.

# Connect to SharePoint
Connect-PnPOnline -Url https://your-sharepoint-site-url -UseWebLogin

# Get all sites
$sites = Get-PnPTenantSite

# Create an array to store inactive sites
$inactiveSites = @()

foreach ($site in $sites) {
    $siteUrl = $site.Url

    # Get site statistics
    $siteStatistics = Get-PnPTenantSiteStatistics -SiteId $site.SiteId

    # Define criteria for site inactivity (customize as needed)
    $daysSinceLastActivity = (Get-Date) - $siteStatistics.LastActivityDate
    $minimumDaysInactive = 90  # Adjust this value based on your criteria

    if ($daysSinceLastActivity.Days -ge $minimumDaysInactive) {
        $inactiveSites += [PSCustomObject]@{
            SiteUrl = $siteUrl
            LastActivityDate = $siteStatistics.LastActivityDate
            DaysInactive = $daysSinceLastActivity.Days
            InactiveReason = "No recent activity"
        }
    }
}

# Disconnect from SharePoint
Disconnect-PnPOnline

# Export the results to a CSV file
$inactiveSites | Export-Csv -Path "InactiveSitesReport.csv" -NoTypeInformation

What the script does (or trying to do)

1. Uses Get-PnPTenantSiteStatistics to retrieve site statistics, including the LastActivityDate.
2. Calculates the number of days since the last activity on the site.
3. Compares this duration with a minimumDaysInactive value to determine if the site is potentially inactive.
4. If the site meets the criteria for inactivity, it's added to the $inactiveSites array along with relevant information.

Remember to adjust the $minimumDaysInactive value based on your definition of inactivity.

Before running the script, ensure you have the SharePoint PnP PowerShell module installed and configured. You can also download and try to use SharePoint Online Management Shell: 

Download SharePoint Online Management Shell from Official Microsoft Download Center