tests/Test-CmCollectionRefresh.ps1
|
function Test-CmCollectionRefresh { [CmdletBinding()] param ( [parameter()][string] $TestName = "CM Collection Refresh", [parameter()][string] $TestGroup = "configuration", [parameter()][string] $Description = "Validate Collections refresh impact on performance", [parameter()][hashtable] $ScriptParams ) try { [System.Collections.Generic.List[PSObject]]$tempdata = @() # for detailed test output to return if needed $stat = "PASS" $msg = "No issues found" $query = "Select (Case when RefreshType = 1 then 'Manual' when RefreshType = 2 then 'Scheduled' when RefreshType = 4 then 'Incremental' when RefreshType = 6 then 'Scheduled and Incremental' else 'Unknown' end) as RefreshType, count(SiteID) as Collections from v_Collections group by RefreshType" $cdat = Invoke-DbaQuery -SqlInstance $ScriptParams.SqlInstance -Database $ScriptParams.Database -Query $query $c1 = $cdat | Where-Object {$_.RefreshType -eq 'Incremental'} | Select-Object -ExpandProperty Collections $c2 = $cdat | Where-Object {$_.RefreshType -eq 'Scheduled'} | Select-Object -ExpandProperty Collections $c3 = $c1 + $c2 if ($c3 -gt 200) { $stat = "FAIL" $msg = "More than 200 collections are incremental or scheduled" } } catch { $stat = 'ERROR' $msg = $_.Exception.Message -join ';' } finally { Write-Output $([pscustomobject]@{ TestName = $TestName TestGroup = $TestGroup TestData = $tempdata Description = $Description Status = $stat Message = $msg }) } } |