tests/Test-CmClientCoverage.ps1
|
function Test-CmClientCoverage { [CmdletBinding()] param ( [parameter()][string] $TestName = "Test-CmClientCoverage", [parameter()][string] $TestGroup = "operation", [parameter()][string] $Description = "Confirm AD computers managed by CM", [parameter()][hashtable] $ScriptParams ) try { $startTime = (Get-Date) [int]$Coverage = Get-CmHealthDefaultValue -KeySet "configmgr:ClientCoverageThresholdPercent" -DataSet $CmHealthConfig $Threshold = $Coverage * 0.1 Write-Verbose "coverage threshold = $Coverage percent" $stat = "PASS" $except = "WARNING" $msg = "Coverage meets stated threshold of $Coverage percent" [System.Collections.Generic.List[PSObject]]$tempdata = @() # for detailed test output to return if needed $adcomps = @(Get-AdsiComputer | Select-Object -ExpandProperty Name) $adcount = $adcomps.Count Write-Verbose "AD computers = $adcount" $query = "select distinct name, clientversion, lasthardwarescan from dbo.v_CombinedDeviceResources where (name not like '%unknown%')" $cmcomps = Get-CmSqlQueryResult -Query $query -Params $ScriptParams $cmcount = $cmcomps.Count Write-Verbose "CM computers = $cmcount" if (($adcount -gt 0) -and ($cmcount -gt 0)) { $actual = $($cmcount / $adcount) * 100 Write-Verbose "actual = $actual" if ($actual -lt $Coverage) { $stat = $except $msg = "$actual percent coverage is below the minimum threshold of $Coverage percent" $tempdata.Add( [pscustomobject]@{AD_Count = $adcount; CM_Count = $cmcount} ) } else { $msg = "$actual percent coverage is above the minimum threshold of $Coverage percent" } } else { $stat = $except $msg = "Unable to query environment data to validate this test" } } catch { $stat = 'ERROR' $msg = $_.Exception.Message -join ';' } finally { $rt = Get-RunTime -BaseTime $startTime Write-Output $([pscustomobject]@{ TestName = $TestName TestGroup = $TestGroup TestData = $tempdata Description = $Description Status = $stat Message = $msg RunTime = $rt Credential = $(if($ScriptParams.Credential){$($ScriptParams.Credential).UserName} else { $env:USERNAME }) }) } } |