Reply to Message

Hi,

Below is changes made for only ( Free Memory & CPU ) as per your instructions,

$time = Get-Date
Get-Cluster -PipelineVariable cluster |
Get-VMHost|
Select @{N='Cluster';E={$cluster.Name}},
    @{N='VMHost';E={$_.Name}},
    @{N='CPU GHz Capacity';E={[math]::Round($_.CpuTotalMhz/1000,2)}},
    @{N='CPU GHz Used';E={[math]::Round($_.CpuUsageMhz/1000,2)}},
    @{N='CPU GHz Free %';E={[math]::Round(($_.CpuTotalMhz - $_.CpuUsageMhz)/1000,2)/100}},
    @{N='Memory Capacity GB';E={[math]::Round($_.MemoryTotalGB,2)}},
    @{N='Memory Used GB';E={[math]::Round($_.MemoryUsageGB,2)}},
    @{N='Memory Free %';E={[math]::Round(($_.MemoryTotalGB - $_.MemoryUsageGB),2)/100}},
    @{N='Timestamp';E={$time}}|
Export-Csv -Path c:\temp\ramdisk\Utilisationreport3.csv -NoTypeInformation -UseCulture

Below is the Ooutput.

Kindly let me whether OUT is correct, If yes... How I place percentage symbol next to Value as per Below 

Thanks,

Kumar