I checked the script again, and indeed, when the HostProfile is Compliant, it wasn't reported.
Try this version
Get-VMHost -PipelineVariable esx
|ForEach-Object -Process {
$obj = New-Object -TypeName PSObject -Property @{
VMHost = $esx.Name
HostProfile = ''
Status = ''
CheckTime = ''
FailType = ''
Expression = ''
FailMessage = ''
}
$hp = Get-VMHostProfile -Entity $esx
if($hp){
$obj.HostProfile = $hp.Name
if($esx.ExtensionData.ComplianceCheckState){
$obj.Status = $esx.ExtensionData.ComplianceCheckState.State
$obj.CheckTime = $esx.ExtensionData.ComplianceCheckState.CheckTime
if($esx.ExtensionData.ComplianceCheckState.State -ne [VMware.Vim.ComplianceResultStatus]::compliant){
$esx.ExtensionData.ComplianceCheckResult.Failure |
ForEach-Object -Process {
$objCopy = $obj | ConvertTo-Json | ConvertFrom-Json
$obj.FailType = $_.FailureType
$obj.Expression = $_.Expression
$obj.FailMessage = $_.Message.Message
$obj
$obj = $objCopy | ConvertTo-Json | ConvertFrom-Json
}
}
else{
$obj
}
}
else{
$obj
}
}
else{
$obj
}
} | Select -Property VMHost,HostProfile,Status,CheckTime,FailType,Expression,FailMessage |
Export-Csv -Path .\report.csv -NoTypeInformation -UseCulture
