tests/Test-CmClientHealth.ps1
|
function Test-CmClientHealth { [CmdletBinding()] param ( [parameter()][string] $TestName = "Client Health Summary", [parameter()][string] $TestGroup = "operation", [parameter()][string] $Description = "ConfigMgr Client Health Status", [parameter()][hashtable] $ScriptParams ) try { $startTime = (Get-Date) #[int]$Setting = Get-CmHealthDefaultValue -KeySet "keygroup:keyname" -DataSet $CmHealthConfig [System.Collections.Generic.List[PSObject]]$tempdata = @() # for detailed test output to return if needed $stat = "PASS" # do not change this $except = "WARNING" # or "FAIL" $msg = "No issues found" # do not change this either # credit to Trevor Jones for the following query at https://smsagent.blog/2016/02/05/client-health-find-all-ccmeval-failed-or-unknown/ $query = "Select sys.Name0 as 'ComputerName', sys.User_Name0 as 'UserName', cs.ClientStateDescription, DATEDIFF(day,sys.Creation_Date0,cs.LastActiveTime) as 'DaysActive', DATEDIFF(day,cs.LastHealthEvaluation,GetDate()) as 'DaysSinceLastEval', sys.Creation_Date0 as 'ClientRegistrationDate', cs.LastActiveTime, cs.LastHealthEvaluation, case when LastEvaluationHealthy = 1 then 'Pass' when LastEvaluationHealthy = 2 then 'Fail' when LastEvaluationHealthy = 3 then 'Unknown' end as 'Last Evaluation Healthy', case when cs.ClientRemediationSuccess = 1 then 'Pass' when cs.ClientRemediationSuccess = 2 then 'Fail' else '' end as 'ClientRemediationSuccess', case when LastHealthEvaluationResult = 1 then 'Not Yet Evaluated' when LastHealthEvaluationResult = 2 then 'Not Applicable' when LastHealthEvaluationResult = 3 then 'Evaluation Failed' when LastHealthEvaluationResult = 4 then 'Evaluated Remediated Failed' when LastHealthEvaluationResult = 5 then 'Not Evaluated Dependency Failed' when LastHealthEvaluationResult = 6 then 'Evaluated Remediated Succeeded' when LastHealthEvaluationResult = 7 then 'Evaluation Succeeded' end as 'LastHealthEvaluationResult', HealthCheckDescription, ResultDetail, ResultCode from dbo.v_CH_ClientSummary cs inner join v_R_System sys on cs.ResourceID = sys.ResourceID left join v_CH_EvalResults eval on cs.ResourceID = eval.ResourceID where cs.ClientStateDescription in ('Active/Fail','Active/Unknown') and DATEDIFF(day,sys.Creation_Date0,cs.LastActiveTime) > 7 Order by ClientStateDescription,ComputerName" [array]$res = Get-CmSqlQueryResult -Query $query -Params $ScriptParams if ($res.Count -gt 0) { $stat = $except $msg = "$($res.Count) clients are reporting as not healthy" } $res | Foreach-Object { $tempdata.Add($_) } } catch { $stat = 'ERROR' $msg = $_.Exception.Message -join ';' } finally { Write-Output $([pscustomobject]@{ TestName = $TestName TestGroup = $TestGroup TestData = $tempdata Description = $Description Status = $stat Message = $msg RunTime = $(Get-RunTime -BaseTime $startTime) Credential = $(if($ScriptParams.Credential){$($ScriptParams.Credential).UserName} else { $env:USERNAME }) }) } } |