Queries the queue tables and counts the number of records using Sitecore PowerShell Extensions.

QueryCleanupQueueCounts.sql

$sql = @"
USE {0}
SELECT COUNT(*) FROM [SCSitecore_Master].[dbo].[EventQueue]
SELECT COUNT(*) FROM [SCSitecore_Master].[dbo].[PublishQueue]
SELECT COUNT(*) FROM [SCSitecore_Master].[dbo].[History]
"@

Import-Function Invoke-SqlCommand

foreach($db in Get-Database | Where-Object {"filesystem" -notcontains $_ }) {
    Write-Verbose "Cleaning up the History, EventQueue, and PublishQueue tables in the $($db.Name) database."
    $connection = [Sitecore.Configuration.Settings]::GetConnectionString($db.Name)
    $builder = New-Object System.Data.SqlClient.SqlConnectionStringBuilder $connection
    $dbName = $builder.InitialCatalog
    $query = [string]::Format($sql, $dbName)
    
    Invoke-SqlCommand -Connection $connection -Query $query -As Scalar
}