tests/Test-CmCollectionRefresh.ps1
|
<#
.NOTES Adapted from example: Source: https://model-technology.com/blog/troubleshooting-slow-collection-evaluation-in-sccm-2012-part-3-aka-how-to-identify-collection-update-loitering/ By original author: Steve Bowman #> function Test-CmCollectionRefresh { [CmdletBinding()] param ( [parameter()][string] $TestName = "Test-CmCollectionRefresh", [parameter()][string] $TestGroup = "configuration", [parameter()][string] $Description = "Validate Collections refresh impact on performance", [parameter()][hashtable] $ScriptParams ) try { [int]$maxcolls = Get-CmHealthDefaultValue -KeySet "configmgr:MaxCollectionRefreshCount" -DataSet $CmHealthConfig Write-Verbose "max collections = $maxcolls" [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, SiteID, CollectionName from v_Collections" if ($ScriptParams.Credential) { $res = @(Invoke-DbaQuery -SqlInstance $ScriptParams.SqlInstance -Database $ScriptParams.Database -Query $query -SqlCredential $ScriptParams.Credential) } else { $res = @(Invoke-DbaQuery -SqlInstance $ScriptParams.SqlInstance -Database $ScriptParams.Database -Query $query) } $c1 = ($res | Where-Object {$_.RefreshType -eq 'Incremental'}) $c2 = ($res | Where-Object {$_.RefreshType -eq 'Scheduled'}) [int]$c3 = $c1.Count + $c2.Count if ($c3 -gt $maxcolls) { $stat = "WARNING" $msg = "Found $c3 collections are set to incremental or scheduled refresh" $c1 | Foreach-Object {$tempdata.Add( "ID=$($_.SiteID), Name=$($_.CollectionName), RefreshType=$($_.RefreshType)")} $c2 | Foreach-Object {$tempdata.Add( "ID=$($_.SiteID), Name=$($_.CollectionName), RefreshType=$($_.RefreshType)")} } } catch { $stat = 'ERROR' $msg = $_.Exception.Message -join ';' } finally { Write-Output $([pscustomobject]@{ TestName = $TestName TestGroup = $TestGroup TestData = $tempdata Description = $Description Status = $stat Message = $msg Credential = $(if($ScriptParams.Credential){$($ScriptParams.Credential).UserName} else { $env:USERNAME }) }) } } |