Hello, cjwirweazel-
First thing is it seems to be listing all the server twice
Using the "-Detailed" switch parameter on Get-Compliance results in two (2) types of objects being returned for each VMHost:
- VMware.VumAutomation.Types.BaselineCompliance
- VMware.VumAutomation.Types.PatchBaselineCompliance (the type with more details)
But, the default properties displayed for the "BaselineCompliance" type do not include the number of patches for me, though, so I am not sure why you get the details twice (I get general info and details for each host, instead of details x 2). What version of the VumAutomation PowerShell snapin are you using? You can grab that info via:
Get-PSSnapin VMware.VumAutomation | ft name,version
But, to just work with the detailed info for each host (and, so, only get one result for each host), you could pipe the Get-Compliance output to Where-Object as such:
Get-VMHost | Get-Compliance | ?{$_ -is [VMware.VumAutomation.Types.PatchBaselineCompliance]}
Of course, that is something to be careful with, because that typename is not necessarily static (it may change in future releases from VMware, if any).
and secondly I want to be able to space it out - i have tried filtering the columns out and it just get different deatils i.e. it lists all the patches and other random things
As for filtering the columns, the Get-Compliance cmdlet is formatting the info in its default output. That is, the default output from the cmdlet is not directly displaying the info returned, but is doing some formatting of the data before returning the table.
You could filter the info and display the remaining info in the same manner by using a new calculated property (if not familiar with the calculated properties, see the full help on Format-Table).
So, the meat of the script would be:
## array of BaselineCompliance objects
$arrPatchBaselineComplianceOnly = Get-VMHost | Get-Compliance | ?{$_ -is [VMware.VumAutomation.Types.PatchBaselineCompliance]}
## make the calculated property hashtables
$hshBaselineDisplay = @{n="Baseline"; e={$_.Baseline.Name}; a="left"}
$hshCompliantPatchesCount = @{n="NumCompliant"; e={@($_.CompliantPatches).Count}; a="left"}
$hshNotCompliantPatchesCount = @{n="NumNotCompliant"; e={@($_.NotCompliantPatches).Count}; a="left"}
## put the formatted info into a variable to be put into the email
$strEmailBody = $arrPatchBaselineComplianceOnly | ft entity,$hshBaselineDisplay,$hshCompliantPatchesCount,$hshNotCompliantPatchesCount -a
##...send email here...
How does that do for you?
