Most executed Solr queries from latest Sitecore logs

Find-MostExecutedSolrQuery.ps1

# Gets the latest 30 log files, filters only solr query lines from them, groups them by query content and orders by most executed,
# Letting you find things that are most effective to cache.

Set-HostProperty -HostWidth 2000

$logFileFilter = "azure.log.*"
$logfileCountToAnalyse = 30
$minQueryOccurence = 20

Get-ChildItem $SitecoreLogFolder -Recurse -Filter $logFileFilter `
    | Sort -Property LastWriteTime -Descending `
    | Select -first $logfileCountToAnalyse `
    | Get-Content `
    | ? {$_.Contains("INFO  Solr Query - ?") } `
    | % { $_.Substring($_.IndexOf("Solr Query - ?")+13) } `
    | Group-Object `
    | ? { $_.Count -gt $minQueryOccurence } `
    | Sort-Object -Property Count -Descending `
    | ft Count, Name

Find-MostExecutedSolrQueryOnDiskDrive.ps1

Clear-Host
# Gets the latest 30 log files, filters only solr query lines from them, groups them by query content and orders by most executed,
# Letting you find things that are most effective to cache.

$logFileFilter = "azure.log.*.*"
$logfileCountToAnalyse = 200
$minQueryOccurence = 100
$SitecoreLogFolder = "C:\Projects\CD Logs\20240522"

$files = Get-ChildItem $SitecoreLogFolder -Recurse -Filter $logFileFilter `
    | Sort -Property LastWriteTime -Descending `
    | Select -first $logfileCountToAnalyse


$files | Get-Content `
    | ? {$_.Contains("INFO  Solr Query - ?") } `
    | % { $_.Substring($_.IndexOf("Solr Query - ?")+13) } `
    | Group-Object `
    | ? { $_.Count -gt $minQueryOccurence } `
    | Sort-Object -Property Count -Descending `
    | ft Count, Name