tests/Test-CmComponentStatusMessages.ps1
|
function Test-CmComponentStatusMessages { [CmdletBinding()] param ( [parameter()][string] $TestName = "Component Status Exceptions", [parameter()][string] $TestGroup = "operation", [parameter()][string] $Description = "Get component status exception messages", [parameter()][hashtable] $ScriptParams ) try { $startTime = (Get-Date) [int] $DaysBack = Get-CmHealthDefaultValue -KeySet "configmgr:ComponentErrorsMaxDaysOld" -DataSet $CmHealthConfig [System.Collections.Generic.List[PSObject]]$tempdata = @() # for detailed test output to return if needed $stat = "PASS" # do not change this $except = "WARNING" $msg = "No issues found" # do not change this either $query = "SELECT DISTINCT sm.Component, sm.MessageID, sm.MachineName, sm.Severity, sm.MessageType, sma.AttributeValue FROM dbo.vStatusMessages AS sm LEFT OUTER JOIN dbo.v_StatMsgAttributes AS sma ON sm.RecordID = sma.RecordID WHERE (sm.Severity IN (-1073741824, -2147483648)) AND (sm.Component NOT IN ('Advanced Client', 'Windows Installer SourceList Update Agent', 'Desired Configuration Management', 'Software Updates Scan Agent', 'File Collection Agent', 'Hardware Inventory Agent', 'Software Distribution', 'Software Inventory Agent')) AND (sm.Time >= DATEADD(dd, -CONVERT(INT,$($DaysBack)), GETDATE()))" $res = Get-CmSqlQueryResult -Query $query -Params $ScriptParams Write-Verbose "returned $($res.Count) items" if ($res.Count -gt 0) { $stat = $except $msg = "$($res.Count) items found within the last $DaysBack days" $res | Foreach-Object { Write-Verbose "adding to testdata queue" $tempdata.Add( [pscustomobject]@{ Component = $_.Component MessageID = $_.MessageID ComputerName = $_.MachineName Severity = $_.Severity MessageType = $_.MessageType Attribute = $_.AttributeValue } ) } } else { Write-Verbose "no results were returned" } } 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 }) }) } } |