Pinpoint the items/docs that hasn't been indexed yet after an update

Summary

This script will enable you to pinpoint the items/docs that hasn't been indexed yet. This can be a useful tool if it looks like Search is kinda slow, and your results seems wrong.

Implementation

• Open VS Code
• Create a new file
• Copy a script below

• PnP PowerShell

Copied

#purpose  Visit each document and listitem in a Site Collection and verify when this object was crawled
#Autor Kasper Larsen Fellowmind DK


$SiteCollectionUrl = "https://[Tenant].sharepoint.com/sites/[SiteCollection]"
$tenantUrl ="https://[Tenant].sharepoint.com"

Connect-PnPOnline -Url $SiteCollectionUrl -Interactive 
#if there are any subsites you will have to extend the script to handle that

$lists = Get-PnPList 
try
{
    foreach($list in $lists)
    {
        Write-Host $list.Title -ForegroundColor Blue
        $listItems = Get-PnPListItem -List $list -PageSize 500 
        foreach($item in $listItems)
        {
            if($list.BaseType -eq "GenericList")
            {
                $localurl = $tenantUrl + $item.FieldValues["FileDirRef"]+"/DispForm.aspx?ID=" + $item.id
            }
            elseif ($list.BaseType -eq "DocumentLibrary") 
            {
                
                $localurl = $tenantUrl+  $item.FieldValues["FileRef"] 
            
            }    
            $results = Get-PnPSearchCrawlLog -Filter $localurl 
            
            if($results)
            {
                Write-Debug $localurl 
                $lastcrawled = Get-Date -AsUTC
                $lastcrawled = $lastcrawled.AddDays(-100)
                foreach($result in $results)  #not sure if the last in the array always is the most resent, hence the iteration
                {
                    if($result.crawltime -gt $lastcrawled)
                    {
                        $lastcrawled = $result.crawltime
                    }
                }
                $lastModified = $item.FieldValues["Modified"]
                if($lastcrawled -lt $lastModified)
                {
                    #the item has been modified and the crawler hasn't picked it up yet
                    Write-Host "Last crawled $lastcrawled , last updated $lastModified" -ForegroundColor Red
                }
            }
        }
    }
}
catch
{
    write-host $_.Exception.Message 
}

Check out the PnP PowerShell to learn more at: https://aka.ms/pnp/powershell

The way you login into PnP PowerShell has changed please read PnP Management Shell EntraID app is deleted : what should I do ?

Contributors

Author(s)
Kasper Larsen

Disclaimer

THESE SAMPLES ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.